The last time I used Access I remember that dates needed to have '#' put around them to parse, while SQL Server can just use single quotes. Is this still the case? What about Oracle?

Hi Pavel, I have found an issue with the 'J' format of the oracle.to_date (text, text) function, it reports wrong results compared to Oracle. On Oracle: SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM ...