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:

ParameterDescription
date expan expression evaluating to timestamp
int millisecondsthe 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)