1:插入oracle时间的mabitis写法
to_date(formatDateTime,'yyyy/MM/dd HH24:mm:ss')
例如to_date(‘2005/01/01 13:14:20’,‘yyyy/MM/dd HH24:mm:ss’)
2:获取oracle时间的mabitis写法
to_char(a.cjsj, 'yyyy-mm-dd') as "applyDate"
3:获取两个分钟差sql
SELECT ROUND(TO_NUMBER(sysdate - to_date('20221101 16:53:01','yyyymmdd hh24:mi:ss')) * 24 * 60) ff FROM dual