I am trying to write a query that grabs one particular day from a timestamp column. The data are ordered in 15 minute chunks like this:
2010-07-07 12:45:00 2010-07-07 13:00:00 2010-07-07 13:15:00 2010-07-07 13:30:00 etc… If I wanted all records from july 7th 2010, I would expect 4 x 24 = 96 records per day. I have tried the '=' operator, like this WHERE derived_tsoil_fifteen_min_stacked.time2 = '2010-07-07*' but that grabs nothing, and using the '~' operator grabs everything with a 2010 or 07 in it… in other words all days from July of 2010. Any suggestions would be much appreciated. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
