• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

date order change,,,

 
Pradeep Adibatla
Ranch Hand
Posts: 336
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I declared a column in table as:

The date set in table is of type yyyy-mm-dd .Is this default? I want to change it to dd-mm-yyyy as my values to be set in the table are of the form dd-mm-yyyy

My DB is MySql... how do i change it?
 
Jan Cumps
Bartender
Posts: 2577
11
C++ Linux Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi. The database does not store your date in that format. Your query tool shows it like that, but internally, the date is stored as a numeric value.
You can use the MySQL date formatting functions to show the date as you please.

In a java program, you could format the date using java.text.SimpleDateFormat. To convert your dd-mm-yyyy from String to Date, you can use SimpleDateFormat.parse(). You can then insert that Date in your database. Here is an example of both cases.

Regards, Jan
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic