Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

from Access to MySQL date question

843854Feb 26 2005 — edited Feb 26 2005

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2005

Added on Feb 26 2005

#java-database-connectivity-jdbc

9 comments

90 views