microseconds_sub

description

Syntax

DATETIMEV2 microseconds_sub(DATETIMEV2 basetime, INT delta)

• basetime: Base time whose type is DATETIMEV2
• delta: Microseconds to subtract from basetime
• Return type of this function is DATETIMEV2

example

1. mysql> select now(3), microseconds_sub(now(3), 100000);
2. +-------------------------+----------------------------------+
3. | now(3)                  | microseconds_sub(now(3), 100000) |
4. +-------------------------+----------------------------------+
5. | 2023-02-25 02:03:05.174 | 2023-02-25 02:03:05.074          |
6. +-------------------------+----------------------------------+

now(3) returns current time as type DATETIMEV2 with precision 3，microseconds_sub(now(3), 100000) means 100000 microseconds before current time

keywords

1. microseconds_sub