List fields in databse by Date format

[cody44]

I have entered some information into my SQL table and it lists okay. However I want to change the date format from 0000-00-00 so I want 2005-08-10 to display as 10th August 2005.
Could I also add the day before the date.

Thanks in advance

[wilku]

If you use MySQL you can use DATE_FORMAT() function in your SELECT query to format the date, the way you wan't. Look in mySQL documentation for details.