This is version 1 2 3 4 5 6 7 8 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

TO_DATE#

Functionality:#

This Oracle function converts a string to a date/time format, usually so that subsequent formatting or manipulation can be made

Parameters:#

STRING	the date you want converted from
Format	(optional) the format that the string is in – to be used if different than the default defined in NLS_DATE_FORMAT settings (DD-MON-YYYY)

Returns: #

Date/Time

Errors: #

None

Operations: #

This function is used to take a string and convert it to a date, so that it can be re-formatted or manipulated using a date function. It is recommended that you do explicit data conversions as you may get unexpected results when allowing Oracle's implicit conversion to take place.

Example:#

to_date(~) will convert the string in format DD-MON-YYYY to a date

to_date(~,'YYYYMMDD') will convert the string in format YYYYMMDD to a date for further action