Syntax:
DAYNAME(value:(Number|Date) {, mode:Number})
Returns a text string of the day given by value.
value must be either a number or date value.
If value is a number, usually number 1 represents Sunday, 2 being Monday through 7 being Saturday. Numbers outside the range [1,7] are reduced into this range, and an optional mode value may be used to adjust the calculation.
mode | |
---|---|
1 | Sunday is day one |
2 | Monday is day one |
3 | Monday is day zero |
11 | Monday is day one |
12 | Tuesday is day one |
13 | Wednesday is day one |
14 | Thursday is day one |
15 | Friday is day one |
16 | Saturday is day one |
17 | Sunday is day one |
21 | Monday is day one (ISO 8601) |
150 | Monday is day one (ISO 8601) |
Revisions:
The optional mode parameter was added in 2.24.
Examples:
DAYNAME(7)
returns the text string "Saturday"
DAYNAME(1, 21)
returns the text string "Monday"
DAYNAME(TODAY)
returns today's day name as a text string.
See also WEEKDAY
.