3 time(date + time), Time(date+time) – Metrohm tiamo 2.3 (process analysis) User Manual

Page 92

Advertising
background image

2.4 Formula editor

■■■■■■■■■■■■■■■■■■■■■■

76

■■■■■■■■

tiamo 2.3 (for Process Analysis)

month 1…12

day

1…31

A parameter can be indicated either directly as a number or as a variable
of the type Number. If the parameter does not correspond to the expec-
ted type, it will automatically be converted to this. If this is not possible,
the result of this operation is given as invalid.

Note

Only the integral part is used for all parameters.

A variable of the type Date/Time cannot be transferred as a parameter
here.

Both for the automatic and explicit conversion of a Time to the type
Number, the number of days are counted since December 30, 1899
at 01 hours.

Attention: December 30, 1899 01 hour = 0.00000 days, this number
is rounded off to 5 decimal places, but a relational operation for exam-
ple is carried out with the exact value!

Return value
Date/Time in the format yyyy-mm-dd hh:mm:ss UTC ±xx

Note

UTC = Universal Time , from which the times in the various time zones
of the earth are derived. CET (Central European Time) is equal to UTC
plus 1 hour, in the summer time UTC plus 2 hours.

Examples
Time(2004;02;02) = 2004-02-02 00:00:00 UTC +1 (dependent on
the system time)

Time('CV.Test year';'CV.Test month';'CV.Test day') = Date com-
prised of the common variables

2.4.4.6.3

Time(Date + Time)

Dialog window: Formula editor

Operators/Functions

Syntax
y = Time(year; month; day; hour; minute; second)

Gives the entered numbers in the format Date/Time.

Advertising