Legacy code with Date Format issue

[Rolando Cruz-Marshall]

Hello,

I have inherited legacy code for an application which stores information in an M$Access 2003 database. The data contains quite a few DateTime fields. Although I modified the code to replace "#" with " ' " (date delimiters) I now realize that the date format comes into play.

Date formats within M$Access uses the formats of mm/dd/yyyy or mm/dd/yy while mySQL requires date format to be yyyy/mm/dd. There are literally a couple of thousand places within the legacy code which queries the data using the M$Access date format.

Is there a way to have mySQL recognize and use the dates in mm/dd/yyyy format?

Any information will be helpful.

Thanks.

Rolando E. Cruz-Marshall