Please find attached a patch (diff -c against cvs HEAD) to add a

Bruce Momjian <bruce@momjian.us>

Commit: 4d0e7b4aace5cdad7137d6efe71bcad4015c2518
Author: Bruce Momjian <bruce@momjian.us>
Date: 2005-06-09T16:35:09Z
Releases: 8.1.0
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)

Michael Glaesemann

Files

PathChange+/−
doc/src/sgml/func.sgml modified +14 −1
src/include/catalog/pg_proc.h modified +3 −1