Bhuvan A writes:
> SELECT EXTRACT(EPOCH FROM TIMESTAMP(now()));
> date_part
> ------------
> 1000467997
> (1 row)
>
> Fine..
>
> Similarly, how could i get timestamp value for these SECONDS?
TIMESTAMP 'epoch' + INTERVAL 'N seconds'
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
