microsecond

description

Syntax

INT MICROSECOND(DATETIMEV2 date)

Returns microsecond information in the time type.

The parameter is Datetime type

example

1. mysql> select microsecond(cast('1999-01-02 10:11:12.000123' as datetimev2(6))) as microsecond;
2. +-------------+
3. | microsecond |
4. +-------------+
5. |         123 |
6. +-------------+

keywords

1. MICROSECOND