| 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: | Whole Thread | Raw Message | 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 |