Converting epoc number to timestamp

Поиск
Список
Период
Сортировка
Искать
От
Doug Silver
Тема
Converting epoc number to timestamp
Дата
в 20:30:22
Msg-id
Pine.LNX.4.21.0205091657210.11032-100000@danzig.sd.quantified.net
Список
Дерево обсуждения
Converting epoc number to timestamp Doug Silver <dsilver@urchin.com>
Re: Converting epoc number to timestamp Oliver Elphick <olly@lfix.co.uk>
Selecting random rows using weights "G" <gerard@interfold.com>
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

В списке pgsql-novice по дате отправления
От: John Nix
Дата:
Сообщение: Re: Newbie Date Problems
От: hodges@xprt.net
Дата:
Сообщение: Time Formatting
FAQ