|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
An expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to-DATE Conversion".
In place of a DATE expression, you can specify a text expression that has values conforming to a valid input style for dates. Oracle OLAP automatically converts the values of the text expression to DATE values, using the current setting of the DATEORDER option to resolve any ambiguity.
The value of WEEKDAYSNEWYEAR specifies how many days of the new year there must be in the week for WEEKOF to consider it to be week 1 of the new year. For example, when January 1 is on a Wednesday, then the week of December 29 to January 4 has four days in the new year. WEEKDAYSNEWYEAR must therefore have a value of 4 or less for that week to be counted as week 1. This determination of week 1 affects the numbering of all weeks in the year.
Example 24-40 Finding Today's Week
The following statement sends the week of the year in which today's date falls to the current outfile.
When today's date is August 5, 1996, which is a Monday, this statement produces the following output.