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)

Arguments

date-expression: An expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to-DATE Conversion".

Notes

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.

Examples

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.

SHOW DAYOF(TODAY)

When today's date is January 15, 1997, which is a Wednesday, this command produces the following output.

Example 9-37 Finding the Weekday of a Date

The following command sends the day of the week on which July 4 fell in 1996 to the current outfile.

SHOW DAYOF('04jul96')

This command produces the following output.