Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous section

TODATEDefaultFormat

Default date format for the SQL TO_DATE() function.

Synopsis

[SQL]    TODATEDefaultFormat=n

Description

The value n provides the format string that the SQL TO_DATE() function uses when TO_DATE() is called without a format specified.

Examples

TODATEDefaultFormat=DD MON YYYY

Range of Values

Any string in a format appropriate for the TO_DATE() function. The default string is:

 DD MON YYYY
Copy code to clipboard
Management Portal

No equivalent.