addMilliseconds

Returns a modified date after a specified number milliseconds have been added.

Example

Add 60 milliseconds to the timestamp values in the column TIME_ID.

addMilliseconds(Sales_Acme.Sales.TIME_ID, 60)

Syntax

addMilliseconds(timestamp expr t, int ms)
  • t : expression evaluating to timestamp
  • ms : number of milliseconds as an int

    Returns

    date

Notes

addMilliseconds adds ms milliseconds to the specified date expression, t and returns the modified date as the result. The number of milliseconds can be positive or negative.