ColdFusion developers use the CreateODBCDate(), CreateODBCTime(), and CreateODBCDateTime() extensively when working with dates and times in SQL statements – but those functions may not work if you are using native database drivers because those drivers may not understand the ODBC date format. If you are using native database drivers, and are experiencing problems when using dates, try using the DateFormat() and TimeFormat() functions instead to format the dates as you need them. (Applies to: ColdFusion 4 (or later))

Leave a Reply