TIME real-valued function TIME real-valued function Syntax TIME ( string , select) Function Return an integer value representing either the date or the time specified in the given string parameter. Parameters string Optional string variable, constant, or expression that specifies the date and time in the format described below. (See below for details.) select Real value, variable, or expression (interpreted as an integer) that selects the value to be returned. An error results if select is not one of the following: Details This function can be used to encode the date and time into compact (unsigned 16-bit) integer formats.
After the integer date and time values are obtained, they can be arithmetically compared to other date and time values to determine before and after conditions. NOTE: You should not try to manipulate the encoded integer values to perform date or time arithmetic. For example, you should not attempt to add days to an encoded date value. If the string parameter is supplied, both the date and the time must be specified in the string. The value of the string must have one of the following formats:
dd-mmm-yy hh:mm:ss dd-mmm-yyyy hh:mm:ss dd-mmm-yy hh:mm dd-mmm-yyyy hh:mm eV+Language Reference Guide, v2.x, 18319-000 Rev A Page 529 select Returned Defined ss 1 date (year-1980)*512 + month*32 + day 2 time hour*2048 + minute*32 + second/2 3 seconds time past the minute