MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
MySQL 5.6.4 and up permits fractional seconds for
TIME
,
DATETIME
, and
TIMESTAMP
values, with up to
microseconds (6 digits) precision. See
Section 11.2.7, “Fractional Seconds in Time Values”.
There may be problems replicating from a source server that understands fractional seconds to an older replica that does not:
For CREATE TABLE
statements
containing columns that have an
fsp
(fractional seconds
precision) value greater than 0, replication fails due to
parser errors.
Statements that use temporal data types with an
fsp
value of 0 works with
statement-based logging but not row-based logging. In the
latter case, the data types have binary formats and type
codes on the source that differ from those on the replica.
Some expression results differ on source and replica.
Examples: On the source, the timestamp
system variable returns a value that includes a microseconds
fractional part; on the replica, it returns an integer. On
the source, functions that return a result that includes the
current time (such as
CURTIME()
,
SYSDATE()
, or
UTC_TIMESTAMP()
) interpret an
argument as an fsp
value and the
return value includes a fractional seconds part of that many
digits. On the replica, these functions permit an argument
but ignore it.