Oracle millisecond to time, oracle millisecond to time

Oracle millisecond to time, oracle millisecond to time

The date string for data inventory today is like this: 1.3377024E12. I wanted to use the program background to convert it and then display it on the foreground. After thinking about it, you can search for the information as soon as the database is changed:

The implementation is as follows:

SELECT TO_CHAR (to_number (1.3377024E12)/(1000*60*60*24) + TO_DATE ('2017-01-01 08:00:00 ', 'yyyy-MM-DD HH: MI: SS '), 'yyyy-MM-DD HH: MI: ss') finishcasedate from dual;