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?