Microseconds in MariaDB - MariaDB Knowledge Base

The TIME, DATETIME, and TIMESTAMP types, along with the temporal functions, CAST and dynamic columns, support microseconds. The datetime precision of a column can be specified when creating the table with CREATE TABLE, for example: Generally, the precision can be specified for any TIME, DATETIME, or TIMESTAMP column, in parentheses, after the type name. The datetime precision specifies number of d

[krrrr]

mysqlだと日付が変わるけど、mariadbだと日付が変わらない例 SELECT CAST('2009-12-31 23:59:59.998877' as DATETIME);