1.0

The argument must be a time, timestamp, or a valid character string representation of a time or timestamp that
is not a CLOB, LONG VARCHAR, or XML value. The result of the function is an integer between 0 and 24.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Syntax
HOUR ( expression )
Example
Select all the classes that start in the afternoon from a table called TABLE1.
SELECT * FROM TABLE1 WHERE HOUR(STARTING) BETWEEN 12 AND 17
INTEGER function
The INTEGER function returns an integer representation of a number or character string in the form of an integer
constant.
Syntax
INT[EGER] (NumericExpression | CharacterExpression )
An expression that returns a value of any built-in numeric data type. If the argument is
a numeric-expression, the result is the same number that would occur if the argument
NumericExpression
were assigned to a large integer column or variable. If the whole part of the argument
is not within the range of integers, an error occurs. The decimal part of the argument is
truncated if present.
An expression that returns a character string value of length not greater than the maximum
length of a character constant. Leading and trailing blanks are eliminated and the resulting
CharacterExpression
string must conform to the rules for forming an SQL integer constant. The character
string cannot be a long string. If the argument is a character-expression, the result is the
same number that would occur if the corresponding integer constant were assigned to
a large integer column or variable.
The result of the function is a large integer. If the argument can be null, the result can be null; if the argument
is null, the result is the null value.
Example
Using the EMPLOYEE table, select a list containing salary (SALARY) divided by education
level (EDLEVEL). Truncate any decimal in the calculation. The list should also contain
the values used in the calculation and employee number (EMPNO). The list should be in
descending order of the calculated value:
SELECT INTEGER (SALARY / EDLEVEL), SALARY, EDLEVEL, EMPNO
FROM EMPLOYEE
ORDER BY 1 DESC
LCASE or LOWER function
LCASE or LOWER takes a character expression as a parameter and returns a string in which all alpha characters
have been converted to lowercase.
vFabric SQLFire User's Guide528
vFabric SQLFire Reference