to_timestamp overloaded to convert from Unix epoch

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема to_timestamp overloaded to convert from Unix epoch
Дата
Msg-id 0B80ACA6-EC21-11D8-831D-000A95C88220@myrealbox.com
обсуждение исходный текст
Ответы Re: to_timestamp overloaded to convert from Unix epoch  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: to_timestamp overloaded to convert from Unix epoch  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: to_timestamp overloaded to convert from Unix epoch  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Please find attached a patch (diff -c against cvs HEAD) to add a
function that accepts a double precision argument assumed to be a Unix
epoch timestamp and returns timestamp with time zone, and accompanying
documentation.

Usage:

test=# select to_timestamp(200120400);
       to_timestamp
------------------------
  1976-05-05 14:00:00+09
(1 row)

If regression tests are required, I will produce some. I'd appreciate
any pointers as to what to look for, as they would be my first attempt
at writing regression tests.

Regards

Michael Glaesemann
grzm myrealbox com


Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] SAVEPOINT syntax again
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: more massaging on pgxs postresql extension infrastructure