Time(date + time), Functions - type conversion, Numbertotext – Metrohm tiamo 1.1 Manual User Manual
Page 78

50
General program functions
Time(Date + Time)
Syntax
y = Time(year; month; day; hour; minute; second)
Returns the entered numbers in the format
Date/Time
.
Parameter
year
00...99 or 1000...9999
month
1...12
day
1...31
hour
0...23
minute
0...59
second
0...59
The parameter can either be entered directly as a number or as a Variable
of the type
Number
. If the parameter does not correspond to the selected
type then it will be automatically converted to it (see Type conversion
"TextToNumber"). If this is not possible then "
invalid
" will be returned as the
result of this operation.
Note
Only the whole number part will be used for all parameters.
A variable of the type
Date/Time
cannot be transferred as a parameter here.
In both the automatic and the explicit conversion of a
Time into the type Num-
ber the number of days since 30 December 1899 at 01 a.m. will be counted.
Note: 30 December 1899 01 a.m. = 0.00000 days, this number is rounded to 5
decimal places; however, in e.g. a comparative operation it will be 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 Coordinated: reference time for the different time zones
on the earth. MET (Mean European Time) equals UTC plus 1 hour, in the sum-
mer time UTC plus 2 hours.
Examples
Time(2004;06;02;10;30;25) = 2004-06-02 10:30:25 UTC +2
(depends on the
system time)
Time('CV.Testyear';'CV.Testmonth';'CV.Testday';'CV.TestHour';'CV.TestMin';'CV.T
estSec')
= date complied from the Common variables
Functions - Type conversion
NumberToText
Syntax
y = NumberToText(Number)
Returns the entered number as
Text
.