Re: to_timestamp overloaded to convert from Unix epoch

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-patches by date

  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