转成long型:
select (FIRSTARRIVALTIME - to_date('1970-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')) *24*60*60 from ats_plat_time_info;
select (sysdate - to_date('1970-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')) *24*60*60 from dual;
转成char型:
select to_char(FIRSTARRIVALTIME, 'yyyy-mm-dd hh24:mi:ss') from ats_plat_time_info;
select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') from dual;
从long插入:
select to_date('1970-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') + 1332342490/24/60/60 from dual;