날짜 형식 변환

SELECT *
FROM
  (SELECT ROWNUM RNUM ,
    A.BOARD_ID AS BOARD_ID,
    A.SEQ      AS SEQ,
    A.TITLE    AS TITLE,
    A.CONTENT  AS CONTENT,
    A.NAME     AS NAME,
    A.READ_CNT AS READ_CNT,
    A.DEL_YN   AS DEL_YN,
    TO_CHAR(SYSDATE,'yyyy-mm-dd') AS REG_DATE     
  //          이런식으로
  FROM
    (SELECT *
    FROM TB_BOARD
    WHERE DEL_YN = 'N'
    AND BOARD_ID = 'BOARD001'
    ORDER BY SEQ DESC
    ) A
  )
WHERE RNUM BETWEEN 0 + 1 AND 0 + 10