oracle做全年日历表,Oracle之一份标准日历表的构建

select TO_NUMBER(to_char(everyDay,‘yyyymmdd‘)) as ID,

everyDay as CODE,

to_char(everyday,‘yyyy‘)||‘年‘||TO_NUMBER(to_char(everyday,‘mm‘))||‘月‘||TO_NUMBER(to_char(everyday,‘dd‘))||‘日‘ AS NAME,

TO_NUMBER(to_char(everyday,‘yyyy‘)) as YEAR_ID,

to_char(everyday,‘yyyy‘)||‘年‘ as YEAR_NAME,

CASE WHEN TO_NUMBER(to_char(everyday,‘mm‘))<=6 THEN 1 ELSE 2 END AS SEMESTER_ID,

CASE WHEN TO_NUMBER(to_char(everyday,‘mm‘))<=6 THEN ‘上半年‘ ELSE ‘下半年‘ END AS SEMESTER_NAME,

CASE WHEN TO_NUMBER(to_char(everyday,‘mm‘))<=3 THEN 1

WHEN TO_NUMBER(to_char(everyday,‘mm‘))<=6 THEN 2

WHEN TO_NUMBER(to_char(everyday,‘mm‘))<=9 THEN 3

ELSE 4 END AS QUARTER_ID,

CASE WHEN TO_NUMBER(to_char(everyday,‘mm‘))<=3 THEN ‘一季度‘

WHEN TO_NUMBER(to_char(everyday,‘mm‘))<=6 THEN ‘二季度‘

WHEN TO_NUMBER(to_char(everyday,‘mm‘))<=9 THEN ‘