Built-in Functions → addMilliseconds
addMilliseconds() is a scalar date function that returns a modified date after a specified number milliseconds have been added. The number of milliseconds can be positive or negative.
Signature
addMilliseconds(date exp, int milliseconds)
The following table illustrates the addMilliseconds() parameters:
| Parameter | Description |
|---|---|
| date exp | an expression evaluating to timestamp |
| int milliseconds | the number of milliseconds as an int |
Returns
date
Example
Add 60 milliseconds to the timestamp values in the column TIME_ID.
addMilliseconds(Sales_Acme.Sales.TIME_ID, 60)