TODATEDefaultFormat Contents Description Changing This Parameter 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 the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book). FeedbackOpens in a new tab
