In some cases, EnterpriseDB allows data of one data type where it expects data of a different data type. Generally, an expression cannot contain values with different data types. However, EnterpriseDB can use the following functions to explicitly convert data to the expected data type:
This is the case when we must always explicitly cast to the to type -
e.g., CAST(TEXT '123' AS INT4)
Following are some of the data type conversion functions supported by EnterpriseDB.
CAST()
TO_ASCII()
TO_HEX()
TO_CHAR()
TO_DATE()
TO_TIMESTAMP()
TO_NUMBER()