RE: [PHP] MySQL Query Question

> The MySQL manual has a chapter on date/time factions. Or is it > the 'order > by' clause that's giving you trouble...? I assume that 'date' is a > reserved word, so it may be confusing mysql. In which case, try using a > different alias, like 'f_date". This works: select date_format(date, "%W, %e %M %Y") as date from table This doesn't: select concat(date_format(date, "%W, %e %M %Y")," ",time) as time_of_day I'm wondering if it is possible to use concat in this way and how if it is possible. Maybe this is a question better suited for the MySQL list. Thanks! Jeff