I have a PostgreSQL timestamp as
2009-12-22 11:01:46
I need to change this to date as
2009-12-22
So that I can compare the dates in postgreSQL
How can I achieve this transformation?
Add a comment
|
3 Answers
Cast it to date.
SELECT yourtimestamp::date;
If you need to extract other kinds of stuff, you might want to use EXTRACT or date_trunc
Both links are to the same page, were you'll find more date/time-related functions.
Comments
You can either use one of the Postgres date functions, such as date_trunc, or you could just cast it, like this:
SELECT timestamp '2009-12-22 11:01:46'::date
>>> 2009-12-22
1 Comment
pupitetris
date_trunc ('day', yourtimestamp) will return a timesamp, but with hours, mins and secs to zero. It will not convert the value to a date. The cast is the correct anwser.
SELECT [timestamp column] ::date;
Along in select query you can search on the basis of date
WHERE [timestamp column] :: date = '2022-05-30'
