oracle数据库数值类型转换为时间类型:
select TO_DATE('19700101','yyyymmdd')+ in_number/86400+TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone),1,3))/24 ) num_to_date
from dual;
oracle数据库数值类型转换为时间类型:
select TO_DATE('19700101','yyyymmdd')+ in_number/86400+TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone),1,3))/24 ) num_to_date
from dual;