What would be the correct query to convert a date stored in MySQL in a
DATETIME field to month_name month_date, year format at the same time I'm
pulling a bunch of other data from the same row as the field with the
date I need converted? I've tried something like the below without
success:
SELECT name,city,state,country,message,DATE_FORMAT(post_timestamp,
'%M %d, %Y),website_url,website_name FROM table
With the above MySQL comes back with a syntax error... Where have I gone
wrong? Probably something obvious... But hey, I'm just learning SQL. :)
Thanks,
Alec
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
