change sql date format

[fsaghar]

hello every one i m working on very simple database program for my office but i m having trouble with date format in phmysql 2.61 i just wanna change dafault value of date faild
it's showing " 0000-00-00 " but i want " 00-00-0000 " day-month-year ...................... is it possible to change this dafault value thru any config file of sql ?
please help me

[NogDog]

I do not think you can change the way the database stores the data, but it's easy to change how it's output:

SELECT DATE_FORMAT(`date_column`, '%m-%d-%Y) FROM `table_name`;

If you need to insert/update a mm-dd-yyyy value:

INSERT INTO `table_name` (`date_column`) VALUES (STR_TO_DATE('02-22-2006', '%m-%d-%Y));

[fsaghar]

thanks for ur reply but this command isn't working for me at all
i use this is sql replied [QUOTE]
DATE_FORMAT(`date`,
'%d-%m-%y')
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
\0\0d\0-\0\0m\0-\0\0y
i m using this ............... structure = date type = date null = no dafault= 0000-00-00
please help me how to solve this problem
i tried this command SELECT DATE_FORMAT(`date`, '%d-%m-%y) FROM `table_name`;
SELECT * FROM `abl
but it's still showin 00day-month-year 0000-00-00

please help me

[chazzy]

please clarify, what exactly did you put into your sql statement?

[fsaghar]

let me explain what i m trying to make ............... i m working on a bank database for my office wanna make statment but "date" is really trouble for me ..............
i just wannt date format day-month-year ...............