Converting epoc number to timestamp
От
Doug Silver
Тема
Converting epoc number to timestamp
Дата
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 по дате отправления