Re: epoch to timestamp
От | Lucas Lain |
---|---|
Тема | Re: epoch to timestamp |
Дата | |
Msg-id | 20030512120544.5bb9c4c6.lainl@aconectarse.com обсуждение исходный текст |
Ответ на | Re: epoch to timestamp (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: epoch to timestamp
Re: epoch to timestamp |
Список | pgsql-sql |
i really dont know how to do it ... i'm a newbie it is something like this? select cast(105471234 AS abstime) ... and then? On Fri, 9 May 2003 16:36:48 -0500 Bruno Wolff III <bruno@wolff.to> wrote: > On Fri, May 09, 2003 at 18:05:45 -0300, > Lucas Lain <lainl@aconectarse.com> wrote: > > > > can anyone tell me how to convert an epoch date to timestamp format?? > > If the epoch date is an integer with seconds since the unix epoch, > you can cast it to abstime and then to timestamp. > -- Lucas Lain lainl@aconectarse.com
В списке pgsql-sql по дате отправления: