Please enable JavaScript to view this site.

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 Descriptions

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)