Data Type Conversion |
Table: 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.
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. |