# tgl@xxxxxxxxxxxxx / 2005-01-11 18:35:18 -0500:
> Roman Neuhauser <neuhauser@xxxxxxxxx> writes:
> > what is the opposite of cast(extract('epoch' from now()) as int)?
> > The only thing I found that works is
> > cast(cast(... as abstime) as timestamp)
> > and the documentation says abstime shouldn't be used, and may
> > disappear. What should I use instead?
>
> The recommended locution is
>
> SELECT TIMESTAMP WITH TIME ZONE 'epoch' + <x> * INTERVAL '1 second';
Have I missed this in the manual?
> Of course you can wrap this up in a function if you prefer (not sure why
> we haven't done so already).
I most surely will, and I'm glad to hear this will be included in 8.1.
Thanks for the replies!
--
FreeBSD 4.10-STABLE
1:25AM up 17:04, 9 users, load averages: 0.11, 0.06, 0.01
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
