Oracle和JDE日历转换
普通日期->儒日历：
方法1:
select substr(TO_date('2019-06-10','yyyy-mm-dd'),2,1)+1||substr(TO_date('2019-06-10','yyyy-mm-dd'),3,2)||to_char(to_date('2019-06-10','yyyy-mm-dd'),'DDD') from dual;
方法2:
SELECT TO_CHAR(TO_DATE('1929-05-29','YYYY-MM-DD'),'YYYYDDD')-1900000 FROM DUAL;
--开始和结束日期换算：
SELECT TO_CHAR(TO_DATE('2023-05-01','YYYY-MM-DD'),'YYYYDDD')-1900000 start_date,TO_CHAR(TO_DATE('2023-05-31','YYYY-MM-DD'),'YYYYDDD')-1900000 end_date FROM DUAL;
--sysdate->儒日历：
SELECT TO_CHAR(sysdate,'YYYYDDD')-1900000 FROM DUAL;
儒日历->普通日期
select to_date(substr(119162,4,3),'ddd') from dual;
###日期转时间戳
select cast(to_date('2016/8/19','yyyy-mm-dd,hh24:mi:ss') as timestamp) date_to_timestamp from dual;
###时间戳-》date
select TO_CHAR(to_timestamp('2016/8/19','yyyy-mm-dd hh24:mi:ss') ,'YYYY-MM-DD HH24:MI:SS')
from dual
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14661773/viewspace-3006473/ ，如需转载，请注明出处，否则将追究法律责任。
