Converting Timestamp to Month without the 00:00:00

Question

I have a timestamp that looks like this:

2022-01-23 03:50:48

I want it to look like this:

2022-01-01

However, it currently looks like this:

2022-01-01 00:00:00

My SQL Logic: , DATE_TRUNC('month', DATE(timestamp)) as reporting_month

Is there anyway I can make it look like just the month and the year?

user_2501279 · Answer

Use date_format to format date value:

select date_format(now(), '%Y-%m-%d')

_col0
2022-04-27

Or cast timestamp to date:

select date(now())