작업일지

날짜 조회(EIS개발)

소마후니 2015. 9. 14. 18:48

-DEFINE BASE_DT = '20090402'

--SelDual00
--날짜 조회
 
SELECT /*+ MG$SelDual00 작성자 영업지원_황해훈 */
       /*!type char(8)*/ /*!기준일 */:BASE_DT                    /*! type char ( 8) */ /*!기준일      */ BASE_DT,
       TO_CHAR(TO_DATE(:BASE_DT,'YYYYMMDD')-1,'YYYYMMDD')        /*! type char ( 8) */ /*!전일        */ PR_BASE_DT,
       SUBSTR(:BASE_DT,1,6) || '01'                              /*! type char ( 8) */ /*!당월시작일  */ THIS_MONTH_START_DT,
       SUBSTR(TO_CHAR(ADD_MONTHS(TO_DATE(:BASE_DT,'YYYYMMDD'),-12),'YYYYMMDD'),1,4)||'0101'
                                                                  /*! type char ( 8) */ /*!전년시작일  */ PRE_YEAR_START_DT,
       SUBSTR(TO_CHAR(ADD_MONTHS(TO_DATE(:BASE_DT,'YYYYMMDD'),-12),'YYYYMMDD'),1,4)||'1231'
                                                                  /*! type char ( 8) */ /*!전년마지막일  */ PRE_YEAR_END_DT,
       SUBSTR(TO_CHAR(ADD_MONTHS(TO_DATE(:BASE_DT,'YYYYMMDD'),-1),'YYYYMMDD'),1,6) || '01'
                                                                  /*! type char ( 8) */ /*!전월시작일  */ PRE_MONTH_START_DT,
       TO_CHAR(LAST_DAY(ADD_MONTHS(TO_DATE(:BASE_DT,'YYYYMMDD'),-1)),'YYYYMMDD')
                                                                  /*! type char ( 8) */ /*!전월마지막일*/ THIS_MONTH_END_DT,
       SUBSTR(TO_CHAR(TO_DATE(:BASE_DT,'YYYYMMDD'),'YYYYMMDD'),1,4)||'0101'
                                                                  /*! type char ( 8) */ /*!당년시작일  */ THIS_YEAR_START_DT

FROM DUAL


저작자표시 비영리 변경금지