Re: converting epoch to timestamp

From: Richard Huxton <dev(at)archonet(dot)com>
To: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: converting epoch to timestamp
Date: 2005-10-26 09:22:25
Message-ID: 435F4AD1.3070605@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2005-10-26 09:25:16 Re: converting epoch to timestamp
Previous Message Rajesh Kumar Mallah 2005-10-26 09:05:51 converting epoch to timestamp