oracle date YYYY-MM-DD 변환

        SELECT
            PRO_ID as id,
            PRO_NAME as name,
            TO_CHAR(PRO_START_DATE, 'YYYY-MM-DD HH24:MI:SS') as startDate,
            TO_CHAR(PRO_CLOSE_DATE, 'YYYY-MM-DD HH24:MI:SS') as closeDate,
            PRO_PROGRESS as progress    
        FROM
            PJ_PROJECT 
        WHERE
            PRO_ID = #{id}
 
            //밀리세컨드 YYYY-MM-DD 변환 함수
            TO_CHAR(PRO_START_DATE, 'YYYY-MM-DD HH24:MI:SS') as startDate,
            TO_CHAR(PRO_CLOSE_DATE, 'YYYY-MM-DD HH24:MI:SS') as closeDate,