Q:

Getting weekday string and not number in mysql

I want to get the Day of the week as a string and not an integer value from a datetime column from the MySQL Table. So instead of getting 0,1,2.. I would like to have these as Sunday, Monday, tuesday and so on. Is there a date function to achieve this?

A:

Seems you are looking for DAYNAME  
 SELECT DAYNAME("2008-05-15") from dual 

