Thread: convert from datepart('epoch', now()) to Date / time

convert from datepart('epoch', now()) to Date / time

From
jltsix4@yahoo.com (John Turner)
Date:
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