This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Mysql Date Format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mysql Date Format" Watch "Mysql Date Format" New topic
Author

Mysql Date Format

Amirtharaj Chinnaraj
Ranch Hand

Joined: Sep 28, 2006
Posts: 236
can MYsql Date format be changed to

some other than yyyy-mm-dd like dd-mm-yyyy

i know that in oracle8i it is possible

advance thanks

regards
amir
Shilpa Tendulkar
Ranch Hand

Joined: Jul 29, 2001
Posts: 75
Originally posted by Amirtharaj Chinnaraj:
can MYsql Date format be changed to

some other than yyyy-mm-dd like dd-mm-yyyy

i know that in oracle8i it is possible

advance thanks

regards
amir


Yes you can. Use mysql's DATE_FORMAT(date,format) function


SCJP5
 
GeeCON Prague 2014
 
subject: Mysql Date Format