[To_Date_(disambiguation)] !!!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|DATE FORMAT MODELS (Oracle)] 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 [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.TO_DATE] [{InsertPage page='Internal.TO_DATE' default='Click to create a new discussion page'}] }]