Re: How to Get Timestamp From SECONDS?

Поиск
Список
Период
Сортировка
Искать

Re: How to Get Timestamp From SECONDS?

От:
Hans-Juergen Schoenig <hs@bachata.cybertec.at>
Дата:
Try it with something like that:

mydata=# SELECT '1-1-2001'::timestamp + '200 seconds'::interval;       ?column?
------------------------2001-01-01 00:03:20+01
(1 row)


epoch + seconds = desired timestamp.
   Hans

How to Get Timestamp From SECONDS?

От:
Bhuvan A <bhuvansql@yahoo.com>
Дата:


Hi all,

Consider this..

SELECT EXTRACT(EPOCH FROM TIMESTAMP(now()));date_part
------------1000467997
(1 row)

Fine..

Similarly, how could i get timestamp value for SECONDS?
ie.. VICE VERSA


Something like this..

:)

select extract(timestamp from interval('1000467997 seconds'));

:)


Kindly Apologize for any inconvenience.

    ======================================================================			       "Help Mr. Wizard!"			      -- Tennessee Tuxedo				    ======================================================================

Regards,
Bhuvaneswar.
FAQ