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

Поиск
Список
Период
Сортировка
От jltsix4@yahoo.com (John Turner)
Тема convert from datepart('epoch', now()) to Date / time
Дата
Msg-id 2f901797.0301281451.e5627c@posting.google.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Mariusz Czułada
Дата:
Сообщение: Re: Status of tablespaces
Следующее
От: Francisco J Reyes
Дата:
Сообщение: Re: Status of tablespaces