What is the correct syntax for the date type with ODBC?

Abstract: What is the correct syntax for the date type with ODBC?

Problem: What is the correct syntax for inserting/updating a DATE field using ODBC? Solution: The information in this article applies to: * InterBase 5.1.1 for Win95/NT and earlier * All InterBase ODBC drivers up to 2.0.9.3(Visigenic) The syntax depends somewhat upon which version of the ODBC driver you are using. The syntax which will work for both the 1.0.8.8 and the 2.0.9.3 drivers is: INSERT into (column_name) values ('mm-dd-yyyy') or ('dd-MON-yyyy'); The escape clause 'd' works in 1.0.8.8 but not in 2.0.9.3 as in: UPDATE SET ={d 'mm-dd-yyyy'} WHERE [argument];