PostgreSQL Conversion Function | Notes |
CAST | PostgreSQL does not preserve trailing spaces when casting CHARs to VARCHARs, so results may differ when a federated data source or TDV is set to honor trailing spaces. PostgreSQL data types have the following restrictions for the CAST function: • Maximum CHAR length is 2000. • Maximum VARCHAR length is 4000. • Maximum numeric precision (p) is 38. • Maximum numeric scale (s) is 38. |
FORMAT_DATE | |
PARSE_TIMESTAMP | |
TO_CHAR | |
TO_DATE | |
TO_NUMBER | |
TO_TIMESTAMP |