Re: Converting epoch to timestamp?

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема Re: Converting epoch to timestamp?
Дата
Msg-id 20010801072929.A19443@cc.usu.edu
обсуждение исходный текст
Ответ на Re: Converting epoch to timestamp?  ("Richard Huxton" <dev@archonet.com>)
Список pgsql-sql
On Wed, Aug 01, 2001 at 09:28:39AM +0100, Richard Huxton wrote:

> Hi Roberto - long time no see.
Hey Richard. Yeah. Summer classes and summer jobs :-) I have to finish
my expanded "Porting From Oracle" thingy.

>
> richardh=> select '1970-01-01'::date + '996654342 seconds'::interval;
>         ?column?
> ------------------------
>  2001-08-01 08:25:42+01
> (1 row)
Duh! Guess I could have thought of that. Thanks a lot.
-Roberto
-- 
+------------| Roberto Mello - http://www.brasileiro.net |------------+    Computer Science, Utah State University -
http://www.usu.edu     USU Free Software & GNU/Linux Club - http://fslc.usu.edu        Space Dynamics Lab, Developer
http://www.sdl.usu.edu
Veni, Vidi, VCR - I came, I saw, I videotaped it


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

Предыдущее
От: "Richard Huxton"
Дата:
Сообщение: Re: Converting epoch to timestamp?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Converting epoch to timestamp?