By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable (id INT AUTO_INCREMENT PRIMARY KEY, Created DATETIME , Updated DATETIME)
INSERT INTO mytable (id, Created, Updated) VALUES (null, NOW(), NOW())
INSERT INTO mytable (id, Created, Updated) VALUES (null, NOW(3), NOW(3))
SELECT MICROSECOND(Created),MICROSECOND(Updated) FROM mytable
| MICROSECOND(Created) | MICROSECOND(Updated) |
|---|---|
| 0 | 0 |
| 0 | 0 |
CREATE TABLE mytable2 (id INT AUTO_INCREMENT PRIMARY KEY, Created DATETIME(3) , Updated DATETIME(3))
INSERT INTO mytable2 (id, Created, Updated) VALUES (null, NOW(3), NOW(3))
SELECT MICROSECOND(Created),MICROSECOND(Updated) FROM mytable2
| MICROSECOND(Created) | MICROSECOND(Updated) |
|---|---|
| 186000 | 186000 |