TIBCO Data Virtualization®
>
TDV Support for SQL Functions
>
Convert Functions
>
TRUNCATE
TRUNCATE
The TRUNCATE function is the same as TRUNC for date/time and numeric expressions. Refer to
TRUNC (for numbers)
,
TRUNCATE can also be used in a SQL script to remove (“chop”) a specified number of elements from a VECTOR.