File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Date Format change Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Date Format change" Watch "Date Format change" New topic

Date Format change

Dan Silva
Ranch Hand

Joined: Sep 05, 2007
Posts: 86
I want the date to be displayed with MM\DD\YYYY instead of the default, with the year first. What's the command to do this. Thanks
Dan Silva
Ranch Hand

Joined: Sep 05, 2007
Posts: 86
Sorry, I'm looking to do this in SQL. Thanks.
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 40399
I had a look in the MySQL manual and found this. Look particularly at the first additional comment at the bottom.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716

If its part of JDBC, use ResultSet.getDate() and Java's SimpleDateFormat to change the format. The specific command varies on different databases.

My Blog: Down Home Country Coding with Scott Selikoff
I agree. Here's the link:
subject: Date Format change