beautypg.com

7 type conversion functions, 1 numbertotext, Numbertotext – Metrohm tiBase 1.1 User Manual

Page 64

background image

2.4 Formula editor

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

56

■■■■■■■■

tiBase 1.1

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;06;02;10;30;25) = 2004-06-02 10:30:25 UTC +2
(dependent on the system time)

Time('CV.TestYear';'CV.TestMonth';'CV.TestDay';'CV.Tes-
tHour';'CV.TestMin';'CV.TestSek')
= Date comprised of the common
variables

2.4.4.7

Type Conversion functions

2.4.4.7.1

NumberToText

Dialog window: Formula editor

Operators/Functions

Syntax
y = NumberToText(numberl)

Gives the entered number as Text.

Parameters
Number

The parameter can be indicated either directly as a number or as a variable
of the type Number.