Data type formatting functions

Using a data type formatting function, you can convert values from one data type to another. For each of these functions, the first argument is always the value to be formatted and the second argument contains the template for the new format. AWS Clean Rooms supports several data type formatting functions.

Topics

• CAST function
• CONVERT function
• TO_CHAR
• TO_DATE function
• TO_NUMBER
• Datetime format strings
• Numeric format strings
• Teradata-style formatting characters for numeric data