wood burning stoves 2.0*
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
 
 
subject: Mysql Date Format