ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(I) |
Warning: In the case of ADELIA programs, this function is not compatible with C generator.
Description
This predefined function is used to calculate the number of units between two specific timestamps.
Syntax
Result = &TMS_INTERVAL(Beginning date;End date;Unit)
Parameters
|
Description |
Contents |
Controls |
Result |
NUM_E or NUM_P type numeric variable of length <= 15 with 0 decimals. |
Number of units between the two timestamps given as parameters. |
|
Beginning |
TIMESTAMP variable. |
Start timestamp for the calculation. |
Mandatory parameter. |
End |
TIMESTAMP variable. |
End timestamp for the calculation. |
Mandatory parameter. |
Unit |
Two-position alphanumeric constant or variable. |
Possible values: Y Year M Month D Day H Hour MI Minute S Second MS Microsecond |
Mandatory parameter. |
Note: If the unit is not valid, the obtained result is 0.
Example
TIME TMS1
...
TIME TMS2
RESULT = &TMS_INTERVAL(TMS1;TMS2;'MS')
List of predefined functions by topic