Products Downloads


French version


 

 

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

TIMESTAMP variable.

Start timestamp for the calculation.

Mandatory parameter.

End
Timestamp

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

 

 

↑ Top of page

  • Aucune étiquette