Re: UNIX TIME STAMP

From: Alexander Vysokovskih <av(at)ural(dot)org>
To: Mageshwaran <j_mageshwaran(at)sifycorp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: UNIX TIME STAMP
Date: 2007-04-03 14:58:15
Message-ID: 713873365.20070403205815@ural.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)ural(dot)org

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Karthikeyan Sundaram 2007-04-03 17:42:22 plpgsql function question
Previous Message Sabin Coanda 2007-04-03 06:29:18 Re: recovering using a continuous archive backup doesn'twork on Windows