Thursday, March 3, 2011

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

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

From stackoverflow
  • 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.

0 comments:

Post a Comment