From: | Bhuvan A <bhuvansql(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | |
Date: | 2001-09-14 11:53:01 |
Message-ID: | Pine.LNX.4.20.0109141721220.30965-100000@Larry.bks |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi all,
Consider this..
SELECT EXTRACT(EPOCH FROM TIMESTAMP(now()));
date_part
------------
1000467997
(1 row)
Fine..
Similarly, how could i get timestamp value for these SECONDS?
ie.. VICE VERSA
Something like this..
SELECT EXTRACT(TIMESTAMP FROM INTERVAL('1000467997 SECONDS'));
:)
Kindly Apologize for any inconvenience.
======================================================================
He who invents adages for others to peruse
takes along rowboat when going on cruise.
======================================================================
Regards,
Bhuvaneswar.
From | Date | Subject | |
---|---|---|---|
Next Message | Yoann | 2001-09-14 12:05:49 | Number the lines |
Previous Message | Richard NAGY | 2001-09-14 10:11:41 | SQL request change when upgrade from 7.0.2 to 7.1.3 |