to_date

Converts "expression1" to a datetime value as specified by the format "string_expression2". The first argument "expression1" may be of type string or numeric. "String_expression3" specifies the format elements, such as language.

Syntax

to_date ( expression1 [ , string_expression2 [ ,
 string_expression3 ] ] )

Example 1

to_date ( '2013-02-27 15:13:14' , 'YYYY-MM-DD HH24:MI:SS' )

Result

Returns datetime with value '2013-02-27 15:13:14'.

Example 2

to_date ( '2013-02-27 15:13:14' , 'YYYY-MM-DD HH24:MI:SS' ,
 'NLS_DATE_LANGUAGE = American' )

Result

Returns datetime with value '2013-02-27 15:13:14'.