Change yyyy-mm-dd format

[ngaisteve1]

Currently, the datatype I use is date and I save it in yyyy-mm-dd format. How do I change the datatype into this format 02 April 2004?

Reason of doing so is when I use datepart, it seems got confused between day and month.

[raf]

mysql's date-dataype has a fixed format without customable inputmasks or displayformats.
Reason of doing so is when I use datepart, it seems got confused between day and month. which is a very vague reason + i've never experienced such a problem.