Type-Safe Casting Functions ​

The following SQL functions are supported for compatibility with applications developed in IBM Netezza and other databases. These functions implement type-safe casting from VARCHAR strings to DATE, TIMESTAMP, and DOUBLE data types.

Note: These functions are disabled by default. To enable them system-wide, set the enable_safe_compat_functions_with_nz configuration parameter.