Question

oracle过程中date类型转换unmber类型

Answer 1

select (sysdate-to_date('19700101080000','YYYYMMDDHH24MISS'))*86400 from dual
看看是不是这个
转为自1970年开始的秒数

与程序中取系统时间就保持一致了
time_t t = time(0);
//The time subroutine returns the time in seconds since the Epoch (that is, 00:00:00 GMT, January 1, 1970)

Answer 2

SELECT to_number(to_char(SYSDATE,'yyyymmdd')) FROM dual;
看下是不是你想要的结果！

Answer 3

select to_number(to_char(sysdate,'yyyymmddhhmiss')) from dual;

Answer 4

转成number类型？
to_number(to_char(day_clct,'yyyymmdd'))
这个day_clct为一个date型参数