You are viewing an older version of this section. View current production version.
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