Default Date Format

Previous Next

The DEFAULT_DATE_FORMAT Rules Engine parameter specifies the default IO format to be used when converting a date into a string. The default value is DD-MON-YY.

This Rules Engine parameter is effective in two different situations:

When the SQL functions TO_CHAR and TO_DATE are used without an IO format string. This only happens if the statement is evaluated locally, and only applies to Oracle.

When an implicit conversion takes place from a date to a string or vice versa. This only happens if the statement is evaluated locally, and applies to several databases. However, most databases do not support implicit conversions, so if such a statement is executed on the RDBMS it will fail.

collapseSetting up the DEFAULT_DATE_FORMAT Rules Engine parameter
collapseSQL functions TO_CHAR and TO_DATE (Oracle)
collapseImplicit conversion

 

 

See Also

Domains

IO Formats