 <p>Try to create the table as below:</p> <pre><code>CREATE TABLE t1 (dt DATETIME(6) NOT NULL); </code></pre> <p><strong><a href="http://sqlfiddle.com/#!9/a9086/1/0" rel="nofollow">SQL Fiddle</a></strong></p>