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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to