oracle日期相关操作

1. 查询当前时间 :  select sysdate from dual

2. 查询当天数据 : select * from tableName where   to_char(dateColumn,'yyyy-MM-dd') = to_char(sysdate,'yyyy-MM-dd')

3..查询当月数据 : select * from tableName where   to_char(dateColumn,'yyyy-MM') = to_char(sysdate,'yyyy-MM')

4. 查询5天前到现在的数据 : select * from tableName where dateColumn> sysdate - 5 and dateColumn< sysdate

5. 查询3个月前到现在的数据 : select * from tableName where dateColumn > add_months(sysdate, -3) and dateColumn < sysdate