does anyone know why I get the following error? running postgres 7.3.1
test=> select date(date_part('epoch','now'::date)::int);
ERROR: Bad date external representation '1042502400'
better yet does anyone have a better way to convert unixtime back to standard readable time?