to_timestamp overloaded to convert from Unix epoch - Mailing list pgsql-patches

From Michael Glaesemann
Subject to_timestamp overloaded to convert from Unix epoch
Date
Msg-id 0B80ACA6-EC21-11D8-831D-000A95C88220@myrealbox.com
Whole thread Raw
Responses Re: to_timestamp overloaded to convert from Unix epoch
Re: to_timestamp overloaded to convert from Unix epoch
Re: to_timestamp overloaded to convert from Unix epoch
List 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


Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] SAVEPOINT syntax again
Next
From: Fabien COELHO
Date:
Subject: Re: more massaging on pgxs postresql extension infrastructure