Hey

I have a database with a table including blog entries and a date the date is set to year-month-day format, How can i change it to something else, as i tried to change it to day-month-year so it will look like 11 September 2009 for example

Thanks

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html, or the appropriate documentation for your unnamed database.

You can use like this

select date_format(date, '%d %M %Y') as formatted_date from table_name;

Where date is the name of your date field, and formatted_date is a variable name which you can use to retrieve the value.