날짜 관련 SQL

     SELECT TO_CHAR(SYSDATE,'YYYYMMDD') today,
               TO_CHAR(SYSDATE -1,'YYYYMMDD')  yesterday,
               TO_CHAR(SYSDATE,'MONTH DD, YYYY') yearmonth,
               TO_CHAR(SYSDATE,'YYYY.MM.DD HH24:MI:SS') fullyear,
               TO_CHAR(SYSDATE,'MONTH')  month,
               TO_CHAR(SYSDATE,'MON')    mon,
               TO_CHAR(SYSDATE,'DAY')    daykor ,
               TO_CHAR(SYSDATE,'DY')     daykor1,
               TO_CHAR(SYSDATE,'A.M.')   am,
               TO_CHAR(SYSDATE,'HH')     hh,
               TO_CHAR(SYSDATE,'MI')     mi,
               TO_CHAR(SYSDATE,'SS')     ss,
               TO_CHAR(SYSDATE,'YYYYMM')||'01'  startyear,
               TO_CHAR(LAST_DAY(SYSDATE),'YYYYMMDD')  lastday,
               TO_CHAR(SYSDATE -7,'YYYYMMDD')         lastweek,
               TO_CHAR(SYSDATE +7,'YYYYMMDD')         nextweek,
               TO_CHAR(SYSDATE -14,'YYYYMMDD')        twolast,
               TO_CHAR(SYSDATE +14,'YYYYMMDD')        twonext,
               TO_CHAR(ADD_MONTHS(SYSDATE,-1),'YYYYMMDD')  lastmonth,
               TO_CHAR(ADD_MONTHS(SYSDATE,-2),'YYYYMMDD')  twolastmon,
               TO_CHAR(ADD_MONTHS(SYSDATE,-3),'YYYYMMDD')  threelastmon,
               TO_CHAR(ADD_MONTHS(SYSDATE,1),'YYYYMMDD')   nextmonth,
               TO_CHAR(ADD_MONTHS(SYSDATE,1)-1,'YYYYMMDD') yesterday,
               TO_CHAR(ADD_MONTHS(SYSDATE,-12),'YYYYMMDD') lastyear,
               TO_CHAR(ADD_MONTHS(SYSDATE,12),'YYYYMMDD')  nextyear,
               TO_CHAR(SYSDATE,'YYYYMMDDHHMISS')           fulltime,
               TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')         fulltime1,
               TO_CHAR(SYSDATE +7,'YYYYMMDDHH24MISS')      ,
               TO_CHAR(SYSDATE,'YYYY/MM/DD')               ,
               TO_CHAR(SYSDATE+1,'YYYYMMDDHHMISS')         ,
               TO_CHAR(SYSDATE,'YYYY')||'01'||'01'         startday1,
               TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'))-1)||'01'||'01' lastyearstartday,
               TO_CHAR(SYSDATE,'YYYY')||'12'||'31'     lastday,
               TO_CHAR(SYSDATE,'YYYY')                 year,
               SUBSTR(TO_CHAR(SYSDATE,'YYYY'),2,3)     year,
               to_char(add_months(sysdate,-11),'YYYYMMDD') last11mon
       FROM DUAL;