MILLISECONDS_ADD
Descriptionβ
Adds a specified number of milliseconds to a datetime value and returns a new datetime value.
Syntaxβ
MILLISECONDS_ADD(<basetime>, <delta>)
Parametersβ
| Parameter | Description |
|---|---|
<basetime> | The input datetime value, of type DATETIMEV2 |
<delta> | The number of milliseconds to add, of type INT; 1 second = 1,000 milliseconds = 1,000,000 microseconds |
Return Valueβ
Returns a value of type DATETIMEV2, representing the time value after adding the specified number of milliseconds to the input datetime. The precision of the return value is the same as that of the input parameter basetime.
Exampleβ
SELECT MILLISECONDS_ADD('2023-09-08 16:02:08.435123', 1);
+--------------------------------------------------------------------------+
| milliseconds_add(cast('2023-09-08 16:02:08.435123' as DATETIMEV2(6)), 1) |
+--------------------------------------------------------------------------+
| 2023-09-08 16:02:08.436123 |
+--------------------------------------------------------------------------+
Note:
- In the example, after adding 1 millisecond, the time increases from .435123 to .436123.
- 1 millisecond equals 1000 microseconds.
- The function's result is dependent on the precision of the input time; the example uses a precision of 6 decimal places.
