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 обсуждение исходный текст |
| Ответы |
Re: Converting epoc number to timestamp
Selecting random rows using weights |
| Список | pgsql-novice |
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 по дате отправления: