Re:

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bhuvan A <bhuvansql(at)yahoo(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re:
Date: 2001-09-14 14:10:09
Message-ID: Pine.LNX.4.30.0109141609300.691-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

  • at 2001-09-14 11:53:01 from Bhuvan A

Browse pgsql-sql by date

  From Date Subject
Next Message --CELKO-- 2001-09-14 15:18:18 Re: group by weirdness
Previous Message Bhuvan A 2001-09-14 13:25:37 How to Get Timestamp From SECONDS?