tag:blogger.com,1999:blog-1135944569112521190.post3220859616191990823..comments2024-03-28T08:20:49.787+01:00Comments on Daniël's Database Blog: time for standardsDaniël van Eedenhttp://www.blogger.com/profile/14757324605223498151noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1135944569112521190.post-36814830051209640392013-10-27T10:20:19.714+01:002013-10-27T10:20:19.714+01:00MySQL 5.6 does support fractional seconds precisio...MySQL 5.6 does support fractional seconds precision:<br /><br />mysql> select current_timestamp(6);<br />+----------------------------+<br />| current_timestamp(6) |<br />+----------------------------+<br />| 2013-10-27 10:15:10.919796 |<br />+----------------------------+<br />1 row in set (0.00 sec)<br /><br />However, the default precision was chosen to be zero, for backwards compatibility.Roy Lysenghttps://www.blogger.com/profile/10744503595046905469noreply@blogger.comtag:blogger.com,1999:blog-1135944569112521190.post-81109444951045804222013-10-27T00:35:45.707+02:002013-10-27T00:35:45.707+02:00In standard SQL the default timestamp precision is...In standard SQL the default timestamp precision is 6, or, as the 9075-2 document puts it: "If timestamp precision is not specified, then 6 is implicit." -- Peter Gulutzan, ocelot.ca/blog<br />Anonymoushttps://www.blogger.com/profile/02616590943660523003noreply@blogger.com