NLS_DATE_FORMAT

This specifies the default date format to use with the TO_CHAR and TO_DATE functions.

Property

Description

Parameter type

String

Syntax

NLS_DATE_FORMAT = "format"

Default value

Derived from NLS_TERRITORY

Recommended Value

DD-MON-RRRR

Oracle FLEXCUBE relevance

FLEXCUBE standard date format.

Parent topic: Database Initialization Parameters