![]() ![]() Makes the appearance of the date components (day name, month number, and so forth) depend on the NLS_TERRITORY and NLS_LANGUAGE parameters. Returns a value in the long date format, which is an extension of the Oracle Database DATE format, determined by the current value of the NLS_DATE_FORMAT parameter. ![]() This element depends on the NLS territory of the session. If the last 2 digits of a 4-digit year are 00, then the century is the same as the first 2 digits of that year.įor example, 2002 retureturns 20.ĭay of week (1-7). If the last 2 digits of a 4-digit year are between 01 and 99 (inclusive), then the century is one greater than the first 2 digits of that year. Meridian indicator with or without periods. Punctuation and quoted text is reproduced in the result. Timestamp TZ Format: YYYY-MM-DD HH24:MI:SSXFF TZR.Timestamp Format: YYYY-MM-DD HH24:MI:SSXFF.Now change the entries “Date Format”, “Timestamp Format” and “Timestamp TZ Format” as you wish!.In the tree on the left open the “Database” branch and select “NLS”.Go to the “Tools” menu and open “Preferences…”.You can decide how SQL-Developer display date and timestamp columns.
0 Comments
Leave a Reply. |