TIME, TIMESTAMP, and DATETIME do not support parts of seconds (for example from DATE_FORMAT().

When converting an integer to string, ZEROFILL is honored with prepared statements in some cases where the MySQL server doesn't print the leading zeros. (For example, with MIN(number-with-zerofill)).

When converting a floating point number to a string in the client, the rightmost digits of the converted value may differ slightly from those of the original value.

Prepared statements do not use the Query Cache, even in cases where a query does not contain any placeholders. See Section 5.13.1, “How the Query Cache Operates”.