ADELIA |
VADELIA |
SADELIA |
WADELIA |
EADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(B) |
Warning: In the case of ADELIA programs, this function is not compatible with C generator.
Description
This predefined function is used to calculate a timestamp by adding a number of microseconds, seconds, hours, days, months or years to a given timestamp.
Syntax
Result = &CALCULATE_TMS(Timestamp;Number of units;Unit)
Parameters
Description |
Contents |
Controls |
|
Result |
TIMESTAMP variable. |
Timestamp calculated. |
|
Timestamp |
TIMESTAMP variable. |
Start timestamp to which the number of units is added. |
Mandatory parameter. |
Number of units |
Numeric integer variable or constant. |
Number of units. |
Mandatory parameter. |
Unit |
Two-position alphanumeric variable or constant. |
Possible values: Y Year M Month D Day H Hour MI Minute S Second MS MicroSecond |
Mandatory parameter. |
Note: If the unit is not a valid value, the result is equal to the input-mode timestamp.
If the obtained date exceeds the 31.12.9999 (*HIVAL), the result is equal to the input-mode timestamp.
Example
TIME TMS
TMS_RESULT = &CALCULATE_TMS(TMS;1;'Y ')
List of predefined functions by topic