it was datetime, and I was unaware of the date_format function. (I had read a version of the f**king manual, but not the most useful link you posted: I was in the doco that came with mysql itself)
At 09:53 AM 3/26/2003 +1100, you wrote:
Hi Daniel
This is a long shot but....
What is the data type of the logdatetime column? If its datetime format or some other non string format - that might be your problem. Try using DATE_FORMAT (http://www.mysql.com/doc/en/Date_and_time_functions.html) instead of the left & replace functions.
As for double or single quotes, I've never known mysql to be picky.
Cheers
Mark
______________ Mark Stanton Web Production Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 www.gruden.com
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
Daniel Morphett Web Developer, DBA www.daemon.com.au
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
