Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

MICROSECOND

Extracts the microseconds (fractional seconds part) from the given datetime.

Syntax

MICROSECOND(dateobj)

Arguments

  • dateobj: a valid date, datetime, time, or parsable datetime string.

Return Type

Integer

Example

SELECT MICROSECOND('2019-03-25 10:15:21.000423') AS MICROSECONDS;
****
+------------------------------+
| MICROSECONDS                 |
+------------------------------+
| 423                          |
+------------------------------+
1 row in set (503 ms)

Related Topics