Is this a datetime/date bug - Mailing list pgsql-general

From Michael A. Koerber SR
Subject Is this a datetime/date bug
Date
Msg-id 3644AEFF.1584DC6C@westford.com
Whole thread Raw
List 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




pgsql-general by date:

Previous
From: Constantin Teodorescu
Date:
Subject: New PgAccess 0.92 beta 1 has been released
Next
From: Dirk Elmendorf
Date:
Subject: Searching Large Objects