Extract date (yyyy-mm-dd) from a timestamp in PostgreSQL

Asked Jun 07 '22 at 05:59

Active Jun 07 '22 at 05:59

Viewed 43 times

I have a timestamp format, 2019-12-12T16:10:02+11:00 and want to only extract the date value 2019-12-12 in PostgreSQL.

I tried SELECT DATE_TRUNC('day', TIMESTAMP '2019-12-12T16:10:02+11:00');

the value return as 2019-12-12 00:00:00.0, any way can completely get rid of the time portion?

asked Jun 07 '22 at 05:59

user2102665

SELECT DATE_TRUNC('day', TIMESTAMP '2019-12-12T16:10:02+11:00')::DATE – Jonas Metzler Jun 07 '22 at 06:10
1

@JonasMetzler: why the date_trunc()? Casting to a date is more than enough – Frank Heikens Jun 07 '22 at 06:26
Of course. You can also remove this. The question for me sounded like the author want to use DATE_TRUNC, but maybe I just understood the question wrong. – Jonas Metzler Jun 07 '22 at 06:36

0 Answers0