From: | Andre Schubert <andre(dot)schubert(at)geyer(dot)kabeljournal(dot)de> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Possible Date-Time Bug???? |
Date: | 2001-11-16 12:26:51 |
Message-ID: | 3BF5060B.3114EC2F@geyer.kabeljournal.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Boes | 2001-11-16 14:25:49 | Upgrading 7.1.2 to .3 |
Previous Message | Mr OCP | 2001-11-16 02:18:06 | Please help |