SELECT TO_DATE('01.Jan.12') FROM DUAL;
SELECT TO_DATE('01.01.2012', 'dd.mm.yyyy') FROM DUAL;
SELECT TO_DATE('01' || '.01.2012', 'dd.mm.yyyy') FROM DUAL;
SELECT TO_DATE('01.' || (NQUATER*3 - 2) || '.' || NRYEAR, 'DD.MM.YYYY') FROM DUAL;
SELECT LAST_DAY(TO_DATE('01.' || (NQUATER*3 - 2) || '.' || NRYEAR, 'DD.MM.YYYY')) FROM DUAL;
SELECT TO_CHAR(LAST_DAY(TO_DATE('01.' || (NQUATER*3 - 2) || '.' || NRYEAR, 'DD.MM.YYYY')),'DD') FROM DUAL;
SELECT TO_DATE("CHAR_COLUMN") FROM EMPLOYES;
SELECT TO_DATE("CHAR_COLUMN",'DD.MM.YYYY') FROM EMPLOYES;
SELECT TO_DATE(E."CHAR_COLUMN",'DD.MM.YYYY') FROM EMPLOYES E;
SELECT TO_DATE('01.01.2012' DEFAULT NULL ON CONVERSION ERROR) FROM DUAL;
SELECT TO_DATE('01.01.2012' DEFAULT NULL ON CONVERSION ERROR, 'dd.mm.yyyy') FROM DUAL;
SELECT TO_DATE('01.01.2012' DEFAULT NULL ON CONVERSION ERROR, 'dd.mm.yyyy', 'NLS_DATE_LANGUAGE = RUSSIAN') FROM DUAL;
SELECT TO_DATE('01.01.2012' DEFAULT '01.01.1970' ON CONVERSION ERROR) FROM DUAL;
SELECT TO_DATE('01.01.2012' DEFAULT '01.01.1970' ON CONVERSION ERROR, 'dd.mm.yyyy') FROM DUAL;
SELECT TO_DATE('01.01.2012' DEFAULT '01.01.1970' ON CONVERSION ERROR, 'dd.mm.yyyy', 'NLS_DATE_LANGUAGE = RUSSIAN') FROM DUAL;
SELECT TO_DATE("CHAR_COLUMN" DEFAULT NULL ON CONVERSION ERROR) FROM DUAL;
SELECT TO_DATE("CHAR_COLUMN" DEFAULT NULL ON CONVERSION ERROR, 'dd.mm.yyyy') FROM DUAL;
SELECT TO_DATE("CHAR_COLUMN" DEFAULT NULL ON CONVERSION ERROR, 'dd.mm.yyyy', 'NLS_DATE_LANGUAGE = RUSSIAN') FROM DUAL;
SELECT TO_DATE("CHAR_COLUMN" DEFAULT '01.01.1970' ON CONVERSION ERROR) FROM DUAL;
SELECT TO_DATE("CHAR_COLUMN" DEFAULT '01.01.1970' ON CONVERSION ERROR, 'dd.mm.yyyy') FROM DUAL;
SELECT TO_DATE("CHAR_COLUMN" DEFAULT '01.01.1970' ON CONVERSION ERROR, 'dd.mm.yyyy', 'NLS_DATE_LANGUAGE = RUSSIAN') FROM DUAL;