"Mark Stanton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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.
Hi Daniel, I tried your replace(left()) (as is, just changed the fieldname) on a datetime and it certainly works fine on mySQL 3.23.53-max-nt on Win2k. Not a great answer (and mySQL version dependant), but you could try wrapping a CAST as datetime around it. Regards, Ben --- 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/
