查询日期属性
select
TO_NUMBER(TO_CHAR(sysdate,'yyyymmdd')) as ID,
TRUNC(sysdate) as FDATE,--日期
TO_CHAR(sysdate,'yyyy') || '-Q' || TO_CHAR(sysdate,'q') as YEAR_QUARTER,--年季度
TO_CHAR(sysdate,'yyyy') || '-' || TO_CHAR(sysdate,'mm') as YEAR_MONTH,--年月
TO_CHAR(sysdate,'yyyy') || '-' || TO_CHAR(sysdate,'ddd') as YEAR_DAY,--年天
TO_CHAR(sysdate,'yyyy-mm-dd') as YEAR_MONTH_DAY,--年月日
EXTRACT(year from sysdate) as YEAR,--年份
TO_NUMBER(TO_CHAR(sysdate,'q')) as QUARTER_OF_YEAR,--当年季度
EXTRACT(MONTH FROM SYSDATE) as MONTH_OF_YEAR,--当年月份
months_between(trunc(sysdate, 'mm'),trunc(sysdate, 'q'))+1 as MONTH_OF_QUARTER,--当季度月份
TO_NUMBER(TO_CHAR(sysdate, 'ww')) as WEEK_OF_YEAR,--当年周
CEIL((TRUNC(sysdate)-TRUNC(sysdate, 'q')+1)/7) as WEEK_OF_QUARTER,--当季度周
TO_NUMBER(TO_CHAR(sysdate, 'w')) as WEEK_OF_MONTH,--当月周
TO_NUMBER(