This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan 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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 230
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mysql Date Format
 
Similar Threads
java.sql.Date
change date format
How to fetch Date Field from excel sheet in Java
java.text.ParseException
Date Problem