Skip to main content

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
Management Portal

No equivalent.

FeedbackOpens in a new tab