title: MySQL 8 timestamp precision in nanoseconds
body: <p>Is it possible to store in MySQL DATETIME or other equivalent datatype with a precision of nanoseconds?</p>
  
  <p>As per <a href="https://dev.mysql.com/doc/refman/8.0/en/fractional-seconds.html" rel="nofollow noreferrer">fractional-seconds documentation</a> it looks to me not possible (max 6 digit sub second precision = 1 usec) but maybe there is another datatype or function that can solve this problem?</p>
  
  <p>I would like to be able to calculate difference between time ranges with precision of nanosecond and would like to avoid storing them in INT and doing my own math.</p>
  
  <p>Perhaps if MySQL does not support this precision at all there is a plugin/extension I could install to get a custom DATETIME precision I could set to nanoseconds (9 digits after second comma)?</p>
  
  <p>If this is not possible is there any RDBMS that supports nanosecond precision? or maybe at least NoSQL (with a function to calculate time diff in nsec precision)?</p>