MySQL Forums
Forum List  »  Microsoft Access

Legacy code with Date Format issue
Posted by: Rolando Cruz-Marshall
Date: October 08, 2005 07:52AM


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.


Rolando E. Cruz-Marshall

Options: ReplyQuote

Written By
Legacy code with Date Format issue
October 08, 2005 07:52AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.