HomeOracle › Time stamp

Time stamp

Some People like to store the time stamp as a millisecond time value, to convert it to date in Oracle:

select to_date(’01-01-1970′,’dd-mm-yyyy’)+ column_name/(1000*60*60*24)

from Table_Name;

Comments are closed.