Postgres Pro
Downloads
Home   >   mailing lists

Re: - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re:
Date
Msg-id Pine.LNX.4.30.0109141609300.691-100000@peter.localdomain
Whole thread Raw
In response to ...  (Bhuvan A <bhuvansql@yahoo.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Bhuvan A
Date:
Subject: How to Get Timestamp From SECONDS?
Next
From: "Maik"
Date:
Subject: Re: Combine query views into one SQL string