DB/Oracle
오라클 DATE to CHAR 변환
lovineff
2020. 6. 4. 17:48
SELECT
SYSDATE
, TO_CHAR(SYSDATE, 'YYYY-MM-DD')
, LTRIM((TO_CHAR(SYSDATE, 'YYYY')), '0') AS YEAR
, LTRIM((TO_CHAR(SYSDATE, 'MM')), '0') AS MONTH
, LTRIM((TO_CHAR(SYSDATE, 'DD')), '0') AS DAY
FROM DUAL