microsecond

description

Syntax

INT MICROSECOND(DATETIMEV2 date)

获得日期中的微秒信息。

参数为 Datetime 类型

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