Whilst working on part of an application I needed JMP to fill the gaps of my dataset using know variables from the imported dataset with the information already contained in my Database. These known variables used specific dates to search the database to find the required information.
There was a requirement for this script to be repeatable. Therefore I did not want to change the format of any of the original columns. I did have a data quality plan with the customer that would ensure the data being used would be in the same format.
The script would be required to pick up the specific date and update variables in a SQL script.
The problem occurred whilst Executing my SQL query and looking in the log file I had an Oracle error (ORA-01843).
Looking on the web I found an article regarding this problem which led me onto another page. This page told me to use the oracle SQL syntax TO_DATE.
Using this syntax around my dates being searched stopped the ODBC driver from stopping the execution of my script.