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:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend