On 2012-04-24, rihad <rihad(at)mail(dot)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?
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'
⚂⚃ 100% natural
In response to
pgsql-general by date
|Next:||From: Valentin Militaru||Date: 2012-04-25 07:26:51|
|Subject: Re: Fractions of seconds in timestamps|
|Previous:||From: Toby Corkindale||Date: 2012-04-25 06:18:37|
|Subject: Bug? Query plans / EXPLAIN using gigabytes of memory|