Note
This variable is introduced since OceanBase Database V2.2.30.
Description
nls_date_format specifies the format of converting a date to a string and the format of implicitly converting a string to a date.
Applicability
This variable is valid only in the Oracle mode of OceanBase Database.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | DD-MON-RR |
| Value range | N/A |
| Applicable scope | |
| Modifiable | Yes. It can be modified using the SET statement. |
| Affect the plan | Yes |
Considerations
The data type of start_date is DATE. The value of start_date is converted to text using the format model specified in the system variable NLS_DATE_FORMAT, and then the result is passed to the SQL text. The datetime format model can simply consist of text enclosed in double quotes.
Examples
Session level
obclient> SET nls_date_format='DD-MON-RR';Global level
obclient> SET GLOBAL nls_date_format='DD-MON-RR';