The DAYNAME function returns the name of a day from a number (0 through 7). DAYNAME can be used in conjunction with the DAYOFWEEK function to extract the day number from the current date. 0 and 7 both represent Sunday..
Category
Date / Time
Syntax
DAYNAME(num)
Parameter and Description
| Parameter | Description |
|---|---|
| num | This is a number from 0 to 7 that identifies particular day of the week. 0 = Sunday 1 = Monday 2 = Tuesday 3 = Wednesday 4 = Thursday 5 = Friday 6 = Saturday 7 = Sunday. |
Example
Return the value TUESDAY from a day number and map it to target field TGT_DAY_NAME.
TGT_DAY.NAME = DAYNAME(2)