oracle to_date

TO_DATE converts a string to a DATE. The string argument can be a CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type. The format argument can be any valid date format. You can also specify the NLS_DATE_LANGUAGE parameter to change the language