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(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'
>
>
>