On 3 Oct 2002, at 15:33, Mark Colvin wrote: > The problem I am having is with the DATE_FORMAT. Running the above query > returns the following for the ‘width’ column. > > 94.40 DATE_FORMAT(d1.created, '%d-%m-%Y'): NULL DATE_FORMAT(d1.amended, > '%d-%m-%Y'): 03-10-2002
Show your PHP code. How exactly are you retrieving the values? This doesn't seem like a problem with MySQL itself but rather with PHP or (much more likely) with your code. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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