1、获取当前日期:不要想着用now(),那是MySQL里面用的,oracle需要使用sysdate
select sysdate from dual
2、格式转化:
字符串-->日期:
select to_date('2017-01-12','yyyy-MM-dd HH24:MI') from dual
日期-->字符串:
select to_char(sysdate,'YYYY/MM/DD') FROM DUAL
3、当前日期相关:
获取当前日期的前一天:
select sysdate - interval '1' day from dual
select sysdate + interval '-1' day from dual
select to_char(sysdate-1,'yyyy-mm-dd HH24:MI:SS') from dual
获取当前日期的前一个月:
select sysdate - interval '1' month from dual
select sysdate + interval '-1' month from dual
select to_char(add_months(trunc(sysdate),-1),'yyyy-mm-dd HH24:MI:SS') from dual
获取当前日期的前一个小时:
select sysdate - interval '1' hour from dual
select sysdate + interval '-1' hour from dual
select to_char(sysdate-1/24,'yyyy-mm-dd HH24:MI:SS') from dual
获取当前日期的前一年:
select to_char(add_months(trunc(sysdate),-1*12),'yyyy-mm-dd HH24:MI:SS') from dual
select sysdate - interval '1' year from dual
select sysdate + interval '-1' year from dual