Automation Engine Script Guide > Ordered by Function > Date and Time > ADD_TIMESTAMP

ADD_TIMESTAMP

Script function: Adds time to a time stamp.

Syntax

ADD_TIMESTAMP(Time Stamp, Time)

Syntax	Description/Format
Time Stamp	Time Stamp from date and time ("YYYY-MM-DD HH:MM:SS"). Format: script literal or script variable
Time	Time ("HH:MM:SS") to be added to a Time Stamp. Format: script literal or script variable Allowed values: 0 to 99 (for each HH, MM and SS)

Syntax

Description/Format

Time Stamp

Time Stamp from date and time ("YYYY-MM-DD HH:MM:SS").
Format: script literal or script variable

Time

Time ("HH:MM:SS") to be added to a Time Stamp.
Format: script literal or script variable

Allowed values: 0 to 99 (for each HH, MM and SS)

Return code
Time stamp in the "YYYY-MM-DD HH:MM:SS" format

Comments

This script function adds time in the "HH:MM:SS" format to a given Time Stamp in the "YYYY-MM-DD HH:MM:SS" format.

In doing so, UTC is used for calculation. This means that summer and winter time are not considered. A maximum value of 99 is allowed for hours, minutes and seconds, so the script function's result can lie a bit more than 4 days after the original time stamp.

Example

In the following example, 24 hours and one second are added to the time stamp. The result "2004-01-01 00:00:01" is written to the activation protocol.

:SET &RET# = ADD_TIMESTAMP("2003-12-31 00:00:00", "24:00:01")
:PRINT &RET#