Is this a datetime/date bug

From: "Michael A(dot) Koerber SR" <mak1(at)westford(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is this a datetime/date bug
Date: 1998-11-07 20:35:12
Message-ID: 3644AEFF.1584DC6C@westford.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using v6.4 I see the following 30-year minus 1-day error:

hist=> select date_part('epoch','11/7/1998'::datetime)::date;
date
----------
11-06-2028
(1 row)

hist=> select date_part('epoch','11/7/1998'::date)::date;
date
----------
11-06-2028
(1 row)

mike

--
Dr Michael A. Koerber
MIT/LL
Radar Imaging Techniques

Browse pgsql-general by date

  From Date Subject
Next Message Constantin Teodorescu 1998-11-07 20:54:47 New PgAccess 0.92 beta 1 has been released
Previous Message Darryl Ross 1998-11-07 19:57:26 Connecting to a database as a specific user.