Re: [PATCHES] Epoch to timestamp conversion function patch

2004-08-04 Thread Michael Glaesemann
On Aug 5, 2004, at 2:03 AM, Tom Lane wrote: I'd suggest just one function epoch_to_timestamp that actually yields timestamptz, and then if casting the result to timestamp is needed it'll happen automatically. That makes sense. Chris mentioned the possibility of using the MySQL FROM_UNIXTIME() syn

Re: [PATCHES] Epoch to timestamp conversion function patch

2004-08-04 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > Please find attached two patches (one for pg_proc.h and another for > supporting documentation) for two SQL functions: > epoch_to_timestamp(integer) and epoch_to_timestamptz(double precision), > which convert from UNIX epoch to the native PostgreS