Just curious if there's a way in Postgres to take an epoch number (UTC)
which is stored as a bigint field and convert it to a timestamp.
perl does it like so:
$ perl -e 'print localtime(1020990264)."\n"'
Thu May 9 17:24:02 2002
Didn't see anything in the stored functions, but wanted to be sure. If
not, would it make sense to create my own function that would do it in the
database or just code it on the front end (i.e. web app)?
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Urchin Corporation http://www.urchin.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~