10 Most Common Functions
Type Casting
To_Text Converts a value to text
To_Text Converts a value to text
[Optional] Date and datetimes can be specially formatted
Date format options:
%Y-%m
%m-%d
%m-%d-%Y
%Y-%m-%d
Datetime format options:
%Y-%m-%d %H:%M:%S
%m/%d/%Y %H:%M:%S
Numeric format options:
TO_TEXT(numeric, "05.3f")
means format the numeric value into 3 decimals, at least 5 characters in length, with0
paddings if needed.
Date & Time Operators
Text Operators
Number Operators
Other