A script-enabled browser is required for this page to function properly.

User NLS Date Format Property

Description

Obtains the current NLS date format mask. This is equal to the value of the NLS_DATE_FORMAT environment variable if it is set. If it is not set, a default value is derived based on the current NLS territory.

Applies to application

Set Not settable from within Oracle Forms.

Refer to Built-in

GET APPLICATION PROPERTY

Note that this property is read-only. That is, you cannot specify it in SET APPLICATION PROPERTY.

For example, if you wanted to set the PLSQL DATE FORMAT property to the current NLS date format mask value, you could code the following in a WHEN-NEW-FORM-INSTANCE trigger in your application:

SET APPLICATION PROPERTY(PLSQL DATE FORMAT,
GET APPLICATION PROPERTY(USER NLS DATE FORMAT)); 

Default

None.


About format masks for dates