[RESOLVED] Get weekday name out of database

[ali_p]

I have been a date formatted as datetime in my mysql table and I would like to out put the day of the week that this date falls on so that I can convert my dates to something like
Monday 12th August.
The DATENAME just isn't working for me. Is there a simple way to associate the week day name with the date in PHP.

Thanks in advance

[cretaceous]

PHP date functions

[bradgrafelman]

ali_p wrote:

I can convert my dates to something like
Monday 12th August.

No reason to do this with PHP; MySQL can do that just fine:

SELECT DATE_FORMAT('%W %D %M', dateColumn) ...

EDIT: Just for reference, see DATE_FORMAT() in the MySQL manual for more info.

[ali_p]

Great stuff, thanks. I don't why I spent so long with DATENAME. For some reason I wasn't sure that the days of the week could not be passed with DATE_FORMAT. Very good to know.

Thanks