Re: converting epoch to timestamp

Rajesh Kumar Mallah wrote:
> Hi,
> 
> Can anyone tell me how to convert epoch to timestamp ?
> 
> ie reverse of :
> 
> SELECT EXTRACT( epoch FROM  now() );

I'd start with either Google or the manuals.

http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html

Scroll down to the section on "epoch" here and see the example.

--   Richard Huxton  Archonet Ltd