Thread: changes to postgres7.3 and date()

For some reason the date function no longer works as expected in 7.3

I am trying to upgrade from postgres7.1 to 7.3 and I cannot get past this error.  I have relied upon it working heavily from previous versions.  I know lots of changes took place in the 7.3 release related to timespan and datetime is this related?

 

on 7.1.1 box

autonotify=> select date(date_part('epoch','now'::date)::int);
    date   
------------
 01-09-2003
(1 row)

 

autonotify=> show datestyle;
NOTICE:  DateStyle is Postgres with US (NonEuropean) conventions
SHOW VARIABLE

 

on the 7.3 box

autonotify=> select date(date_part('epoch','now'::date)::int);
ERROR:  Bad date external representation '1042156800'

 

autonotify=> show datestyle;
DateStyle                                
------------------------------------------
Postgres with US (NonEuropean) conventions
(1 row)

 

is this a change in the date function of 7.3 or do I just have something mis-configured?