Skip site navigation (1) Skip section navigation (2)

From: Darcy Buskermolen <darcy(at)ok-connect(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject:
Date: 2000-08-15 05:35:57
Message-ID: 3.0.32.20000814223556.02b647c0@mail.ok-connect.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Here is an other set of strange bugs I've discovered relateing to dates..



SELECT date_part('day', ('2000-11-1 0:00'::datetime + '-1day'))::int4 AS
days_in_month;

days
----
  31
(1 row)


SELECT date_part('day', (('2000-10-1 0:00'::datetime + '1 month') + '-1
day'))::int4 AS days_in_month;

SELECT date_part('day', date_trunc('month', ('2000-10-1 0:00'::datetime +
'1 month')) + '-1 day')::int4 AS days_in_month;


pgsql-bugs by date

Next:From: Darcy BuskermolenDate: 2000-08-15 05:38:18
Subject: date bug (again)
Previous:From: Tom LaneDate: 2000-08-12 23:25:57
Subject: Re: Fw: PortalHeapMemoryFree error in OpenACS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group