TO_DATE#
Functionality:#
This Oracle function converts a string to a date/time format, usually so that subsequent formatting or manipulation can be madeParameters:#
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/TimeErrors: #
NoneOperations: #
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.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