DATE_FORMAT() problem was with my data, not 8.0.2 updater

When the Dreamweaver 8.0.2 updater came out, I originally reported that it mishandles the MySQL DATE_FORMAT() function in the Test SQL Statement panel. After further testing, and some help from Alexandru Costin of InterAKT, I’ve discovered the problem was with the dates in a test table that I was using. Oops!

The dates had been entered incorrectly into the test table, so the actual values were 0000-00-00 00:00:00. No wonder that DATE_FORMAT() wasn’t able to convert them. However, the nasty problem with Dreamweaver 8.0.2 corrupting SQL queries that use CONCAT() has been confirmed by several people. Let’s hope it gets fixed soon.

4 comments May 14th, 2006