Hello,
i'm new to mysql, so please bear with me...
My database has a field called datafield as datetime. I want to display just
the date
#1 this works but gives the full datetime
$result = mysql_query ("SELECT title, description, url, author, datefield
FROM documents");
#2 All I have read on the web/books suggests that this is what to do
$result = mysql_query ("SELECT title, description, url, author,
date_format(datefield, %M %D %Y') FROM documents");
This just leaves out all dates.
Can anyone see where I'm going wrong
Thank you so much
Jules
---------------------------------------------------------------------
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
