DAYOF
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.
Return Value
INTEGER
Syntax
DAYOF(date-expression)
Parameters
- date-expression
-
An expression that has the DATE data type, or a text expression that specifies a date. Instead 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.
Examples
Example 7-60 Finding Today's Weekday
The following statement sends the day of the week on which today's date falls to the current outfile.
SHOW DAYOF(TODAY)
When today's date is January 15, 1997, which is a Wednesday, this statement produces the following output.
4
Example 7-61 Finding the Weekday of a Date
The following statement sends the day of the week on which July 4 fell in 1996 to the current outfile.
SHOW DAYOF('04jul96')
This statement produces the following output.
5
