Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The YRABSTART option sets the specific 100-year period associated with years that are read or displayed using a two-digit abbreviation.
INTEGER
YRABSTART = year
A four-digit INTEGER
expression that indicates the year at which the 100-year period begins. You can specify any value in the range 1000 to 9999. However, when you specify a value greater than 9900 for year, requests to read or display two-digit year values that correspond to a year later than 9999 result in a return value of NA
. The default is 1950; two-digit year abbreviations are interpreted as being in the range 1950 to 2049 unless a different range is set through YRABSTART.
OLADM1418Example 5-114 Using the Default Value
The following statements specify a date format and send output to the current outfile.
DATEFORMAT = '<Mtextl> <d>, <yyyy>' SHOW MAKEDATE(96 9 13)
These statements produce the following output.
September 13, 1996
OLADM1419Example 5-115 Setting the 100-Year Period for a Date
The following statements set a 100-year period of 2000 to 2099 and send the output to the current outfile.
YRABSTART = 2000 SHOW MAKEDATE(96 9 13)
These statements produce the following output.
September 13, 2096