Type-Safe Casting Functions

The following SQL functions are supported for compatibility with applications developed in 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, run the following commands:
yellowbrick=# alter system set enable_safe_compat_functions_with_nz to true;
WARNING:  Will be effective after the next server configuration reload, or after the next server restart in the case of parameters that can only be changed at server start
yellowbrick=# select pg_reload_conf();
(1 row)