Quoted from message of:
Date: 2001-01-12 14:15:11 PST
>play=> select date_part('epoch', now());
> date_part
>-----------
> 979337212
>(1 row)
>but I don't know of any easy way to go in the other direction except by
>casting to abstime.
> regards, tom lane
---------------------------
Question:
Has there been a function added in 7.2 or 7.3
To convert from a number like
mytest=# select date_part('epoch', now());
date_part
------------------
1043793246.17284
(1 row)
1043793246.17284 --> to a Date / time ?
This is sort of a double post, I asked in Hackers
in a different way, before I ran across this answer
Sorry if trouble
John