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?
See Question&Answers more detail:osI 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?
See Question&Answers more detail:osCast 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.