Tuesday, January 8, 2008

unix timestamp to date

select to_date('01/01/1970', 'dd/mm/yyyy HH24:MI:SS')+ (1197889557.848 / ( 60*60*24)) from dual;

Returns gmt time

No comments:

Post a Comment