Legacy code with Date Format issue
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
Subject
Views
Written By
Posted
Legacy code with Date Format issue
3630
October 08, 2005 07:52AM
1813
October 12, 2005 02:25PM
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.