select TRUNC(SYSDATE ) from dual; //获取当前日期
select TRUNC(SYSDATE - 1) from dual; //获取前一天的日期
select trunc(a.create_time) from zklt_sjjl a;//把日期由:2019/6/12 18:33:04 转换成:2019/6/12
判断日期是否相等:trunc(a.create_time) = trunc(sysdate-1)
SELECT to_char(SYSDATE,'yyyy') FROM dual //获取当前年份
判断年份是否相等:to_char(a.create_time,'yyyy') = to_char(SYSDATE,'yyyy')
SELECT EXTRACT(MONTH FROM sysdate) FROM DUAL; //获取当前月份
select to_char(sysdate,'yyyy-mm-dd hh') from dual //获取当前日期加小时 结果:2019-07-03 10