MySql Date issues

[Anon]

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?

[Anon]

Maybe transform the date before you query.

[jsagara]

By "day that date is," do you mean Mon., Monday, 1, ...? Why won't the date_format function work with multiple tables (i.e., what error messages are you getting? You can find out by calling mysql_error() and mysql_errno())? Will you post a sample query?