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

Reply via email to