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.

Syntax

to_date ( expression1 , string_expression2 )

Example

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'.

Parent topic: DB2