| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: to_timestamp overloaded to convert from Unix epoch |
| Date: | 2004-08-14 16:48:42 |
| Message-ID: | CCF3C014-EE11-11D8-831D-000A95C88220@myrealbox.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-08-14 16:55:34 | Re: to_timestamp overloaded to convert from Unix epoch |
| Previous Message | Philip Warner | 2004-08-14 16:28:03 | pg_restore recognizing $-quotes |