2012/4/25 Jasen Betts :
> On 2012-04-25, Valentin Militaru wrote:
>> This is a multi-part message in MIME format.
>> --050404030901030607030308
>> Content-Type: text/plain; charset=UTF-8; format=flowed
>> Content-Transfer-Encoding: 7bit
>>
>> What about using
>>
>> WHERE f BETWEEN '201
On 2012-04-25, Valentin Militaru wrote:
> This is a multi-part message in MIME format.
> --050404030901030607030308
> Content-Type: text/plain; charset=UTF-8; format=flowed
> Content-Transfer-Encoding: 7bit
>
> What about using
>
> WHERE f BETWEEN '2012-04-23 00:00:00' AND '2012-04-24
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 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'
On 2012-04-24, rihad 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
On 04/24/2012 07:51 PM, rihad 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?
Answering to myself: depends on how timestamp was d
On Wed, Apr 25, 2012 at 12:51 AM, rihad 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 usi
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?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you