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()
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 PostgreSQL
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 PostgreSQL timestamp and
timestamptz data types. The