"Nathan Suderman" <nathan(at)pollstar(dot)com> writes:
> test=> select date(date_part('epoch','now'::date)::int);
> ERROR: Bad date external representation '1042502400'
I think your code was relying on the int->abstime coercion, which was
implicitly invokable before 7.3, but now has to be specified explicitly.
regression=# select date(date_part('epoch','now'::date)::int::abstime);
date
------------
2003-01-13
(1 row)
regards, tom lane