0

Hi everyone! i am developing an application using java and mysql as a database server. the problem is i want to change the default date format in mysql.

i created a table like this;

create table registration
(registrationNo integer primary key,
customerName varchar[50] not null,
regDate DATE not null);

so the progam only accept this date format;
2011-09-22 for the reg date

but i want the date format to be

22/09/2011

is it possible? THANK YOU!

3
Contributors
2
Replies
5
Views
6 Years
Discussion Span
Last Post by anand01
0

The mysql storage format is YYYYMMDD. If you want to enter the data in another format you have to convert it in your application to and from the target date format.

0

we cant modify, The server's internal representation of dates is not something
we can modify.You can change it in your application

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.