On Wed, Apr 25, 2012 at 12:51 AM, rihad <ri...@mail.ru> 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?

I think so. I would recommend either using inclusive-exclusive ranges
(eg WHERE f >= '2012-04-23' AND f < '2012-04-24'), or casting to date
(eg WHERE date(f)='2012-04-23').

(Untested code, might have syntax wrong a bit)

ChrisA

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to