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!