Possible Date-Time Bug????

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

Browse pgsql-admin by date

  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