date bug (again)

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)

Responses

Browse pgsql-bugs by date

  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