From: | Darcy Buskermolen <darcy(at)ok-connect(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | date bug (again) |
Date: | 2000-08-15 05:38:18 |
Message-ID: | 3.0.32.20000814223817.02ccebc0@mail.ok-connect.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
let me try this again...
Here is an other set of strange bugs I've discovered relating to dates.
this bug only rears it's head for 1 day a year form what I can find..
october 31'st, the intent of the queries is to get the last day of a month..
SELECT date_part('day', ('2000-11-1 0:00'::datetime + '-1day'))::int4 AS
days_in_month;
days_in_month
--------------
31
(1 row)
SELECT date_part('day', (('2000-10-1 0:00'::datetime + '1 month') + '-1
day'))::int4 AS days_in_month;
days_in_month
--------------
30
(1 row)
SELECT date_part('day', date_trunc('month', ('2000-10-1 0:00'::datetime +
'1 month')) + '-1 day')::int4 AS days_in_month;
days_in_month
--------------
30
(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrei N.Sobchuck | 2000-08-15 05:43:11 | Re: Segmentation fault. |
Previous Message | Darcy Buskermolen | 2000-08-15 05:35:57 |