tnx
just to round this out, I found the problem. When SQLite was used inline in a C++ app, it put DATE() as the first characters in the BLOB, so MySQL hangs on it. It took me a while to figure it out, not to mention not knowing what I'm going to do with some 2k of entries.
Anyway, sorry to be so long getting back to this.