Description: TO_DATE converts char of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to a value of DATE datatype. The fmt is a datetime model format specifying the format of char. If you omit fmt, then char must be in the default date format. If fmt is J, for Julian, then char must be an integer.
Note that this function does not convert data to any of the other datetime datatypes.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
TO_DATE(<string>)RETURNDATE-- convert a string with default format to a dateTO_DATE(<string>)RETURNDATESELECTTO_DATE('03-MAR-1994')FROM dual;CONVERT a string WITH a specified format TO a DATETO_DATE(<string>,<format mask>)SELECTTO_DATE('03/24/1994','MM/DD/YYYY')FROM dual;-- convert a string with a specified format TO_DATE(<string>,<format mask>)RETURNDATESELECTTO_DATE('March 24, 1994, 8:40 P.P.','MONTH DD, YYYY, HH:MI A.M.','NLS_DATE_LANGUAGE = American')FROM dual;-- This example converts a character string into a date:SELECTTO_DATE('January 15, 1989, 11:00 A.M.','Month dd, YYYY, HH:MI A.M.','NLS_DATE_LANGUAGE = American')FROM DUAL;TO_DATE('
---------
15-JAN-89
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.
