Skip to main content

TODATEDefaultFormat

Set the default date format for the SQL TO_DATE() function.

Synopsis

[SQL]    TODATEDefaultFormat=n

n is any string in a format appropriate for the TO_DATE() function. The default string is DD MON YYYY.

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

The following is an example:

TODATEDefaultFormat=DD MON YYYY

And the following another example:

TODATEDefaultFormat=YYYY DD MM

For more examples and an in-depth discussion about valid date strings, see the format argument description of the TO_DATE reference page.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), in the TO_DATE default format field, enter a valid format string.

To set the desired value for TODATEDefaultFormat from the Terminal, use the SetOption(“ToDateDefaultFormat”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change TODATEDefaultFormat with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

FeedbackOpens in a new tab