Thread: dates
I have a table with column of time stamps of when a row entry was created. How can I get the entries of a particular day (date) from these without having to resort to 'where creation_date like somedate' ?
On Fri, Apr 05, 2002 at 04:14:15PM +0200, mixo <mixo@beth.uniforum.org.za> wrote a message of 13 lines which said: > > I have a table with column of time stamps of when a row entry was created. > How can I get the entries of a particular day (date) from these without > having to > resort to 'where creation_date like somedate' ? select * from MYTABLE where extract (day from MYDATECOLUMN) = extract (day from timestamp '2001-03-08') ; http://www.fr.postgresql.org/users-lounge/docs/7.2/postgres/functions-datetime.html#FUNCTIONS-DATETIME-DATEPART