Postgres Pro
Downloads
Home   >   mailing lists

Re: UNIX TIME STAMP - Mailing list pgsql-admin

From Alexander Vysokovskih
Subject Re: UNIX TIME STAMP
Date
Msg-id 713873365.20070403205815@ural.org
Whole thread Raw
In response to UNIX TIME STAMP  (Mageshwaran <j_mageshwaran@sifycorp.com>)
List pgsql-admin
Tree view 
Hello, Mageshwaran.

> Is there any function in postgresql7.1.3 to convert unix time stamp to
> normal date and time format

select date(timestamp 'epoch' + unixtime_column * interval '1 second') from Table;

--
Regards,
 Alexander Vysokovskih                  mailto:av@ural.org

pgsql-admin by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Re: recovering using a continuous archive backup doesn'twork on Windows
Next
From: Karthikeyan Sundaram
Date:
Subject: plpgsql function question