Re: definative way to place secs from epoc into timestamp

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: definative way to place secs from epoc into timestamp
Дата
Msg-id 2bf00b6e6300e2c76bc3c09fa89e7913@myrealbox.com
обсуждение исходный текст
Ответ на Re: definative way to place secs from epoc into timestamp  (Bret Hughes <bhughes@elevating.com>)
Ответы Re: definative way to place secs from epoc into timestamp  (Bret Hughes <bhughes@elevating.com>)
Список pgsql-sql
On Mar 3, 2005, at 14:42, Bret Hughes wrote:

> also my first two pgsql functions :)
>
> cat ts2int.sql

FWIW, there's a patch in the queue for 8.1 that adds a to_timestamp 
function that converts between Unix epoch and timestamp with time zone.

http://momjian.postgresql.org/cgi-bin/pgpatches2

Doesn't help you now, but it'll be there in the future.

Michael Glaesemann
grzm myrealbox com



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: definative way to place secs from epoc into timestamp
Следующее
От: "Smit"
Дата:
Сообщение: how to monitor the archiving process?