where paydate='21-1月-2003'to_char() EXAMPLE: SELECT TO_CHAR(HIREDATE,'Month DD, YYYY') "New date format" FROM emp WHERE ename = 'SMITH' New date format ------------------------------- December 17, 1980 to_date() EXAMPLE: INSERT INTO bonus (bonus_date) SELECT TO_DATE('January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = American') FROM DUAL
EXAMPLE: SELECT TO_CHAR(HIREDATE,'Month DD, YYYY')
"New date format"
FROM emp
WHERE ename = 'SMITH' New date format
-------------------------------
December 17, 1980
to_date()
EXAMPLE: INSERT INTO bonus (bonus_date)
SELECT TO_DATE('January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = American')
FROM DUAL