jimtimber (4/2/2016)
I've found that it seems to accept the date format "01 JANUARY 2016" but no other format. Not sure why this is a default date type.
In Oracle, you can set your dateformat for the session. What Lowell posted with TO_DATE is correct.
However, I'd suggest opening SQL*Plus and writing your query there to get it working. Once you know you have a working query, introduce other variables into the equation like the Oracle ODBC driver.