select to_char(to_date('19700101','yyyy-mm-dd')+ col1/24*60*1000,'yyyymmdd') from A;
select to_char(to_date('19700101','yyyy-mm-dd')+ col1/24*60*1000,'yyyymmdd') from A;
谢谢各位,shiyiwan和zl3450341都很对,谢谢你们,我写的是下面的: select to_char(to_date('19700101000000','yyyymmddhh24miss')+(1256987526578/(24*60*60*1000)),'yyyymmddhh') into tmpCharDate from dual;
select to_char(to_date('19700101000000','yyyymmddhh24miss')+(1256987526578/(24*60*60*1000)),'yyyymmddhh') into tmpCharDate from dual;