Conversion functions convert a value from one form to another.
Function | Example | Description |
---|---|---|
Cast |
|
Changes the data type of an expression or a null literal to another data type. For example, you can cast a customer_name (a data type of Char or Varchar) or birthdate (a datetime literal). Use Do not use |
IfNull |
|
Tests if an expression evaluates to a null value, and if it does, assigns the specified value to the expression. |
IndexCol |
|
Uses external information to return the appropriate column for the signed-in user to see. |
NullIf |
|
Compares two expressions. If they are equal, then the function returns null. If they are not equal, then the function returns the first expression. You cannot specify the literal NULL for the first expression. |
To_DateTime |
|
Converts string literals of dateTime format to a DateTime data type. |