Changing Date when creating table

[alanrenouf]

When you create a mysql table I use the following for a date field:

testdate date not null,

this creates a date filed with the date formated to YYY-MM-DD.

Is there anyway when creating the table changing the date format to DD-MM-YYY?

i want to do this:

testdate date(dd-mm-yy) not null,

Or is there a setting in the instalation of mysql where you can change the default date layout ?

Any ideas ?