TimestampAdd

Adds an offset to a TIMESTAMP variable.

Syntax

TimestampAdd(TIMESTAMP Timestamp, INT Offset [, INT Part])

Timestamp:

The timestamp to which Offset will be added

Offset:

The offset to add, expressed in units of the part parameter

Part:

Indicates which part to add:

0 – Offset is in years.

1 – Offset is in months.

2 – Offset is in days.

3 - Offset is in hours.

4 - Offset is in minutes.

5 - Offset is in seconds (default)

6 - Offset is in milliseconds

Return Value

The TIMESTAMP variable, or INVALID_TIMESTAMP if invalid.

Related Functions

TimestampCurrent, TimestampDifference, TimestampSub, TimestampToStr, TimeIntToTimestamp, TimestampCreate, TimestampFormat, TimestampGetPart, TimestampToTimeInt

Example

TIMESTAMP t1 = TimestampAdd(Tag1.T, 100); // 100 seconds

TIMESTAMP t2 = TimestampAdd(Tag1.T, 1, 0); // 1 year

See Also

Timestamp Functions