Re: problem with unixtime conversion - Mailing list pgsql-general

"Nathan Suderman" <nathan@pollstar.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