Re: Convert from Seconds-Since-Epoch to Timestamp

Поиск
Список
Период
Сортировка
От Jie Liang
Тема Re: Convert from Seconds-Since-Epoch to Timestamp
Дата
Msg-id 39CA54F2.9818B78@ipinc.com
обсуждение исходный текст
Ответ на Convert from Seconds-Since-Epoch to Timestamp  (Webb Sprague <wsprague100@yahoo.com>)
Ответы Re: Convert from Seconds-Since-Epoch to Timestamp
Список pgsql-sql
Hi, Webb,

I am not quit sure what you really want to do, however, I assume that
following maybe
what you mean:


db=# select interval(reltime '12313221 secs');     interval
--------------------4 mons 22 12:20:21
(1 row)


Webb Sprague wrote:

> Hi all,
>
> How do I convert from seconds (an integer) to
> timestamp?
>
> I am sure it is easy, but I can't find it in the docs,
> so far.
>
> Thanks
> Webb
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com





В списке pgsql-sql по дате отправления:

Предыдущее
От: Webb Sprague
Дата:
Сообщение: Convert from Seconds-Since-Epoch to Timestamp
Следующее
От: "Brian C. Doyle"
Дата:
Сообщение: Re: Convert from Seconds-Since-Epoch to Timestamp