On Jan 12, 2005, at 8:35, Tom Lane wrote:
> The recommended locution is
>
> SELECT TIMESTAMP WITH TIME ZONE 'epoch' + <x> * INTERVAL '1 second';
>
> Of course you can wrap this up in a function if you prefer (not sure
> why
> we haven't done so already).
It's in the queue for 8.1.
<http://candle.pha.pa.us/mhonarc/patches2/msg00090.html>
Michael Glaesemann
grzm myrealbox com