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. 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. Table 9-4 Datetime Format Elements Element (See "Default Datetime Format Template", for a discussion of the default datetime format template.) When template is omitted, any existing date format template for the current definition is deleted and the default datetime format template is used. Many datetime format elements are blank padded to a specific length. The following datetime format elements can be used in timestamp and interval format models, but not in the original DATETIME format model: FF, TZD, TZH, TZM, and TZR. Some datetime format elements cannot be used in the TO_* datetime functions, as noted in Table 2-7, "Datetime Fields and Values". For example, you cannot use 'SYYYY' and 'BC' in the same format string. The total length of a datetime format template cannot exceed 22 charactersįor input format models, format items cannot appear twice, and format items that represent similar information cannot be combined. Keep the following points in mind when creating a template: See Table 9-4, "Datetime Format Elements" for the elements that you can specify in the template. An expression composed of one or more datetime format elements that specifies the format for entering and displaying the values of the current object.
0 Comments
Leave a Reply. |