오라클 날짜 사용방법

TO_CHAR(MI.CREATE_DATE, ''YYYY-MM-DD HH24:MI'')AS CREATE_DATE



SELECT * FROM CHANGES where TO_CHAR(CREATE_DATE,'YYYY') = '2009'

SELECT * FROM CHANGES where TO_CHAR(CREATE_DATE,'YYYY-MM-DD') = '2009-05-04'

 UPDATE ITEM_RESULT set update_DATE = TO_DATE('2013-08-06 20:05:14', 'YYYY-MM-DD HH24:MI:SS')  WHERE SMP_RESULT_no = 1