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 по дате отправления: