![]() Only use with the TS element, separated by white space.Ībbreviated era name e.g., Japanese Imperial, ROC Official, etc.įull era name e.g., Japanese Imperial, ROC Official, etc. Short date format controlled by the NLS_TERRITORY and NLS_LANGUAGE parameters. Only with the TS element, separated by white space. Long date format determined by the NLS_DATE_FORMAT parameter. Name of a day which is controlled by the value of the NLS_DATE_LANGUAGE parameter The first day of week can be Sunday or Monday depending on the value of the NLS_TERRITORY parameter. In case the last 2 digits are between 01 and 99 (inclusive), then the century is one greater than the first 2 digits of that year e.g., 2001 returns 21.ĭay of week (1-7). If the last 2 digits of a y-digit year are 00, the century is the same as the first 2 digits e.g., 2000 returns 20. Meridian indicator with or without periods. The example is based on the the date value 0 15:30:20 Element The following table illustrates the common date format elements. ![]() If you use a date format element in a specific case e.g., uppercase, lowercase, etc., the output will be in the corresponding case.įor example, the date format element 'DAY' returns uppercase word like TUESDAY 'Day' returns 'Tuesday' and 'day' returns 'tuesday'. In this example, the format elements are: DD represents the day, Mon represents the abbreviated name of the month, YYYY represents the 4-digit year, and the character string literal '-' represents the hyphen character. Code language: SQL (Structured Query Language) ( sql )Ī date format model is composed of one or more date format elements.
0 Comments
Leave a Reply. |