> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
