Re: UNIX TIME STAMP

[Alexander Vysokovskih <av@xxxxxxxx>]

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@xxxxxxxx