1.1.1

The other rules depend on whether the second argument is specified:
• If both arguments are specified: The result is a timestamp with the date specified by the first argument and the
time specified by the second argument. The microsecond part of the timestamp is zero.
• If only one argument is specified and it is a timestamp: The result is that timestamp.
• If only one argument is specified and it is a string: The result is the timestamp represented by that string. If the
argument is a string of length 14, the timestamp has a microsecond part of zero.
Syntax
TIMESTAMP ( expression [, expression ] )
Examples
The second column in table records_table contains dates (such as 1998-12-25) and
the third column contains times of day (such as 17:12:30). You can return the timestamp
with this statement:
SELECT TIMESTAMP(col2, col3) FROM records_table
The following clause returns the value 1998-12-25-17:12:30.0:
VALUES TIMESTAMP('1998-12-25', '17.12.30');
1
--------------------------
1998-12-25 17:12:30.0
TRIM function
TRIM is a function that takes a character expression and returns that expression with leading and/or trailing pad
characters removed. Optional parameters indicate whether leading, or trailing, or both leading and trailing pad
characters should be removed, and specify the pad character that is to be removed.
Syntax
TRIM( [ trimOperands ] trimSource)
trimOperands ::= { trimType [ trimCharacter ] FROM | trimCharacter FROM
}
trimType ::= { LEADING | TRAILING | BOTH }
trimCharacter ::= CharacterExpression
trimSource ::= CharacterExpression
If trimType is not specified, it will default to BOTH. If trimCharacter is not specified, it will default to the space
character (' '). Otherwise the trimCharacter expression must evaulate to one of the following:
• a character string whose length is exactly one, or.
• NULL
If either trimCharacter or trimSource evaluates to NULL, the result of the TRIM function is NULL. Otherwise,
the result of the TRIM function is defined as follows:
• If trimType is LEADING, the result will be the trimSource value with all leading occurrences of trimChar
removed.
• If trimType is TRAILING, the result will be the trimSource value with all trailing occurrences of trimChar
removed.
• If trimType is BOTH, the result will be the trimSource value with all leading *and* trailing occurrences of
trimChar removed.
vFabric SQLFire User's Guide586
vFabric SQLFire Reference