Thread: changes to postgres7.3 and date()

changes to postgres7.3 and date()

From
"Nathan Suderman"
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?