Search Postgresql Archives

Re: Fractions of seconds in timestamps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



What about using
WHERE f BETWEEN '2012-04-23 00:00:00' AND '2012-04-24 00:00:00'?


On 04/25/2012 09:52 AM, Jasen Betts wrote:
On 2012-04-24, rihad <rihad@xxxxxxx> wrote:
As PostgreSQL stores timestamps with a fractional part, does it mean that
WHERE f BETWEEN '2012-04-23 00:00:00' AND '2012-04-23 23:59:59' might miss
records with values of f equal to 23:59:59.1234 or so?
yes, it does. BETWEEN doesn't work well for timestamps.
you have to do it the long way 

   f >= '2012-04-23 00:00:00' AND f < '2012-04-24 00:00:00'





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux