SELECT To_Char(SYSDATE,'yyyy-mm-dd') FROM dual; --当天 SELECT To_Char(SYSDATE,'w') FROM dual; --当月第几周 SELECT To_Char(SYSDATE,'ww') FROM dual; --当年第几周 SELECT To_Char(SYSDATE,'mm') FROM dual; --当月 select to_char(sysdate,'q') from dual; --当年第几个季度 SELECT To_Char(SYSDATE,'yyyy') FROM dual; --当年
TRUNC(SYSDATE) TRUNC(SYSDATE)+1-1/24/60/60
-------------- ---------------------------
2010-10-19 2010-10-19 23:59:59
SQL> select trunc(sysdate,'D'),trunc(sysdate+7,'D')-1/24/60/60 from dual;--周
TRUNC(SYSDATE,'D') TRUNC(SYSDATE+7,'D')-1/24/60/6
------------------ ------------------------------
2010-10-17 2010-10-23 23:59:59
SQL> select trunc(sysdate,'mm'),add_months(trunc(sysdate,'mm'),1)-1/24/60/60 from dual;--月
TRUNC(SYSDATE,'MM') ADD_MONTHS(TRUNC(SYSDATE,'MM')
------------------- ------------------------------
2010-10-1 2010-10-31 23:59:59
SQL> select trunc(sysdate,'q'),add_months(trunc(sysdate,'q'),3)-1/24/60/60 from dual;--季度
TRUNC(SYSDATE,'Q') ADD_MONTHS(TRUNC(SYSDATE,'Q'),
------------------ ------------------------------
2010-10-1 2010-12-31 23:59:59
SQL> select trunc(sysdate,'y'),add_months(trunc(sysdate,'y'),12)-1/24/60/60 from dual;--年
TRUNC(SYSDATE,'Y') ADD_MONTHS(TRUNC(SYSDATE,'Y'),
------------------ ------------------------------
2010-1-1 2010-12-31 23:59:59
SQL>
SELECT To_Char(SYSDATE,'yyyy-mm-dd') FROM dual; --当天
SELECT To_Char(SYSDATE,'w') FROM dual; --当月第几周
SELECT To_Char(SYSDATE,'ww') FROM dual; --当年第几周
SELECT To_Char(SYSDATE,'mm') FROM dual; --当月
select to_char(sysdate,'q') from dual; --当年第几个季度
SELECT To_Char(SYSDATE,'yyyy') FROM dual; --当年
to_char(sysdate,'mm') --月份
to_char(sysdate,'yyyy') --年
to_char(sysdate,'q') --季度