beautypg.com

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

Page 78

background image

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

.