Postgres Pro
Downloads
Home   >   mailing lists

Fractions of seconds in timestamps - Mailing list pgsql-general

From rihad
Subject Fractions of seconds in timestamps
Date
Msg-id 4F96BE04.4060609@mail.ru
Whole thread Raw
Responses Re: Fractions of seconds in timestamps
Re: Fractions of seconds in timestamps
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Simple way to get missing number
Next
From: Chris Angelico
Date:
Subject: Re: Fractions of seconds in timestamps