Re: definative way to place secs from epoc into timestamp - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: definative way to place secs from epoc into timestamp
Date
Msg-id 2bf00b6e6300e2c76bc3c09fa89e7913@myrealbox.com
Whole thread Raw
In response to Re: definative way to place secs from epoc into timestamp  (Bret Hughes <bhughes@elevating.com>)
Responses Re: definative way to place secs from epoc into timestamp  (Bret Hughes <bhughes@elevating.com>)
List pgsql-sql
On Mar 3, 2005, at 14:42, Bret Hughes wrote:

> also my first two pgsql functions :)
>
> cat ts2int.sql

FWIW, there's a patch in the queue for 8.1 that adds a to_timestamp 
function that converts between Unix epoch and timestamp with time zone.

http://momjian.postgresql.org/cgi-bin/pgpatches2

Doesn't help you now, but it'll be there in the future.

Michael Glaesemann
grzm myrealbox com



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: definative way to place secs from epoc into timestamp
Next
From: "Smit"
Date:
Subject: how to monitor the archiving process?