ORACLE 날짜함수 샘플

오라클에서 날짜정보를 가져올 때 적용 포맷문자열을 기록하기 위하여 남깁니다.

SELECT TO_CHAR(TRUNC(D.DT,'MM'),'YYYYMMDD') AS "해당월의 첫날"
     , TO_CHAR(LAST_DAY(D.DT),'YYYYMMDD') AS "해당월의 마지막날"
     , TO_CHAR(D.DT,'YEAR') AS "년의 영문명"
     , TO_CHAR(D.DT,'YYYY') AS "년도4자리"
     , TO_CHAR(D.DT,'YY') AS "년도2자리"
     , TO_CHAR(D.DT,'MONTH') AS "개월의 영문명"
     , TO_CHAR(D.DT,'MON') AS "개월의 영문약어"
     , TO_CHAR(D.DT,'MM') AS "개월2자리"
     , TO_CHAR(D.DT,'DAY') AS "요일"
     , TO_CHAR(D.DT,'DY')  AS "요일(약어)"
     , TO_CHAR(D.DT,'D')  AS "주순번(일요일부터)"
     , TO_CHAR(D.DT,'DD')  AS "월일수"
     , TO_CHAR(D.DT,'DDD')  AS "년일수"
     , TO_CHAR(D.DT,'HH')  AS "시간"
     , TO_CHAR(D.DT,'HH24')  AS "24시"
     , TO_CHAR(D.DT,'MI')  AS "분"
     , TO_CHAR(D.DT,'SS')  AS "초"
     , TO_CHAR(D.DT,'AM')  AS "오전/오후"
     , TO_CHAR(D.DT,'PM')  AS "오전/오후"
     , D.*
  FROM (
       SELECT SYSDATE AS DT
         FROM DUAL
       ) D
;