From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: converting epoch to timestamp
Date: Fri, 28 Oct 2005 09:58:46 +0530
Message-ID: <a97c77030510272128x42aab65eke907ba6e9a7e8a05@mail.gmail.com> (raw)
In-Reply-To: <435F4AD1.3070605@archonet.com>
References: <a97c77030510260205n246dcec7rad2818eee629c15@mail.gmail.com>
<435F4AD1.3070605@archonet.com>
On 10/26/05, Richard Huxton <dev@archonet.com> wrote:
> 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
Firstly Thanks everyone for the response.
I did read this document but not too carefully hence missed.
I missed because i was not careful and partly because i was not expecting that
little note to be under documentation of EXTRACT which deals with getting
date/time sub fields. I am no documentation expert just trying to explain
why i could not find it.
PS: sorry for late reply
Regds
Mallah.
>
> Scroll down to the section on "epoch" here and see the example.
>
> --
> Richard Huxton
> Archonet Ltd
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah.rajesh@gmail.com, dev@archonet.com
Subject: Re: converting epoch to timestamp
In-Reply-To: <a97c77030510272128x42aab65eke907ba6e9a7e8a05@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox