problem with unixtime conversion

"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

On Tue, 14 Jan 2003, Nathan Suderman wrote:

better yet does anyone have a better way to convert unixtime back to
standard readable time?

some_unixtime_field::int4::abstime