>Or whenever doing an SQL do not join on datetime() field directly w/o a conversion to ttoc(tdt,1) :)

You got it. This is the same gotcha as trying to SEEK a DATETIME value- it is almost never found, because the actual underlying values are different because of the millisecond precision.