convert from datepart('epoch', now()) to Date / time - Mailing list pgsql-general

From jltsix4@yahoo.com (John Turner)
Subject convert from datepart('epoch', now()) to Date / time
Date
Msg-id 2f901797.0301281451.e5627c@posting.google.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Mariusz Czułada
Date:
Subject: Re: Status of tablespaces
Next
From: Francisco J Reyes
Date:
Subject: Re: Status of tablespaces