Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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