Fractions of seconds in timestamps

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Fractions of seconds in timestamps
Date: 2012-04-24 14:51:48
Message-ID: 4F96BE04.4060609@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Angelico 2012-04-24 14:59:12 Re: Fractions of seconds in timestamps
Previous Message Alban Hertroys 2012-04-24 14:41:26 Re: Simple way to get missing number