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 peter_e@gmx.net http://funkturm.homeip.net/~peter