|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
The DAYOF function returns an integer in the range of 1 through 7, giving the day of the week on which a specified date falls. A result of
1 refers to Sunday. The result has the same dimensions as the specified DATE expression.
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 that conform to a valid input style for dates. DAYOF automatically converts the values of the text expression to DATE values, using the current setting of the DATEORDER option to resolve any ambiguity.
Example 9-36 Finding Today's Weekday
The following command sends the day of the week on which today's date falls to the current outfile.
When today's date is January 15, 1997, which is a Wednesday, this command produces the following output.