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