I am working on an on line appointment scheduler. The date format is in 'yyyy-mm-dd' in MySql, I am trying to find out what day that date is, since the business is only open certain hours of the day different days of the week. I can't figure out how to run the query. The date_format funciton won't work in the query with multiple tables. Do you have any idea on this?