一、本年、本季、本月、本周第一天及最后一天
select trunc(sysdate, 'yyyy') year_begin,
add_months(trunc(sysdate, 'yyyy'), 12) - 1 year_end,
trunc(sysdate, 'Q') quarter_begin,
add_months(trunc(sysdate, 'Q'), 3) - 1 quarter_end,
trunc(sysdate, 'mm') month_begin,
add_months(trunc(sysdate, 'mm'), 1) - 1 month_end,
trunc(sysdate, 'd') week_begin,
trunc(sysdate, 'd') + 6 week_end,
trunc(next_day(sysdate - 8, 1) + 1) week_begin_china,
trunc(next_day(sysdate - 8, 1) + 7) week_end_china
from dual
二、求年內第几周、月内第几周、年内第几天、当天是周几
select to_char(sysdate, 'yyyyiw') as week, --oracle求当年的第几周
to_char(sysdate, 'yyyyww') as week2, --oracle求当年的第几周
to_char(sysdate, 'yyyyddd') as day, --oracle求当年的第几天
to_char(trunc(SYSDATE, 'mm'), 'day'), --月初是周幾
TO_CHAR(SYSDATE, 'W') --當月第幾周
from dual