milliseconds_add

description

Syntax

DATETIMEV2 milliseconds_add(DATETIMEV2 basetime, INT delta)

• basetime: DATETIMEV2 类型起始时间
• delta: 从 basetime 起需要相加的毫秒数
• 返回类型为 DATETIMEV2

example

1. mysql> select milliseconds_add('2023-09-08 16:02:08.435123', 1);
2. +--------------------------------------------------------------------------+
3. | milliseconds_add(cast('2023-09-08 16:02:08.435123' as DATETIMEV2(6)), 1) |
4. +--------------------------------------------------------------------------+
5. | 2023-09-08 16:02:08.436123                                               |
6. +--------------------------------------------------------------------------+
7. 1 row in set (0.04 sec)

keywords

1. milliseconds_add