date to month

PHOTO

Wed Feb 12 2025 17:44:24 GMT+0000 (Coordinated Universal Time)

Saved by @kastokes

to_date(column,'YYYY-MM') AS "month"

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

date reformat

@kastokes

date to month varchar timestamp :: date w/condition date interval conditions extract year_month + filter by year

Browse more snippets >>