MySQL – How do you find the time down to the Millisecond?

Question

Is there any way to get the time down to the Millisecond in MySQL?

Answer 1

MySQL doesn't support milliseconds in any of the time / date columns, or return it in NOW() so unfortunately, no.

If you have a string in a date / time + microseconds format you can use SELECT MICROSECOND('1997-12-31 23:59:59.000010'); to extract the microseconds.