Re: to_timestamp overloaded to convert from Unix epoch

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: to_timestamp overloaded to convert from Unix epoch
Дата
Msg-id CCF3C014-EE11-11D8-831D-000A95C88220@myrealbox.com
обсуждение исходный текст
Ответ на Re: to_timestamp overloaded to convert from Unix epoch  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: to_timestamp overloaded to convert from Unix epoch  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Aug 15, 2004, at 1:19 AM, Tom Lane wrote:

> There was however another patch submitted recently that seemed to
> duplicate yours functionally but used a different syntax --- I think
> the
> guy had started by looking at extract(epoch from timestamp) rather than
> to_timestamp.

Other than Chris' suggestion of extract(timestamp from epoch)? I did
find this documentation patch from December 2003 giving an example of
how to convert from Unix epoch to timestamp, but not a function per se.

http://archives.postgresql.org/pgsql-patches/2003-12/msg00112.php

However, I suspect you may thinking of something else.

Michael Glaesemann
grzm myrealbox com


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

Предыдущее
От: Philip Warner
Дата:
Сообщение: pg_restore recognizing $-quotes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: to_timestamp overloaded to convert from Unix epoch