• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

from Access to MySQL date question

 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I converted my database from access to mySql (altough I believe Access did a great job) So...I realized that the date saved in MySql is in this format: yyyy-dd-mmm while my date saved on Access was dd-MMM-yy (eg 26-FEB-2005).

Question: How can I switch ALL my dates to yyyy-dd-mm??? Does MySql allow other format? I don't want to go thro the entire code (and there's a lot) and switch everything to that format.

anyone?

Thanks
Ppr
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are worrying about use the existing code with the MySql DB, then it doesn't matter if you used prepared statement.

And if your concern is to load all the data present in Access to MySql, then I dont know any third party tool or other service. Hope somebody will help you.
 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks, I realized that there are some diff between the 2 dbs. I just changed my code so MySql will understand the date format...took me a while but it works.

thanks again
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic