A.2 Data Type Conversion

Table A-2, "Data Type Conversion Functions" lists the OLAP DML functions that you to populate variables and relations and to convert data from one data type to another.

Table A-2 Data Type Conversion Functions

Statement	Description
CONVERT	Converts values from one type of data to another.
TCONVERT	Converts data from one dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR to another dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR. You can specify an aggregation method or an allocation method to use in the conversion.
TO_CHAR	Converts a date, number, or NTEXT expression to a TEXT expression in a specified format.
TO_DATE	Converts a formatted TEXT or NTEXT expression to a DATETIME value.
TO_NCHAR	Converts a TEXT expression, date, or number to NTEXT in a specified format.
TO_NUMBER	Converts a formatted TEXT or NTEXT expression to a number.