[ADMIN] Possible Date-Time Bug????

[Andre Schubert]

Hi all,

i think i found a bug in postgresql date/datetime objects.

examples:

select date_trunc('month',date('2002-03-01')+timespan('1
month'))-timespan('24 hours'); 
returns 2002-03-30 23:00:00+01

select date_trunc('month',date('2002-03-01')+timespan('1
month'))-timespan('23 hours');
returns 2002-03-31 00:00:00+01

select date_trunc('month',date('2001-03-01')+timespan('1
month'))-timespan('24 hours');
returns 2001-03-31 00:00:00+02

select date_trunc('month',date('2001-03-01')+timespan('1
month'))-timespan('23 hours');
returns 2001-03-31 01:00:00+02

PostgreSQL 7.1.2 is on a Linux-Box with Immunix RedHat 6.2.

thanks as

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])