|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
YRABSTART = year
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 will 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.
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