Metrohm tiBase 1.1 - Manual (Page 62)

2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
54 ￭￭￭￭￭￭￭￭
tiBase 1.1
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.
2.4.4.6.2 Time(Date)
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Time(year; month; day)
Gives the entered figures in the format Date/Time.
Parameters
year 00…99 or 1000…9999
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