This function returns a dual value with:
- A day name as defined in the environment variable DayNames.
- An integer between 0-6 corresponding to the nominal day of the week (0-6).
Return data type: dual
|date||The date to evaluate.|
If you don't specify first_week_day, the value of variable FirstWeekDay will be used as the first day of the week.
If you want to use another day as the first day of the week, set first_week_day to:
The integer returned by the function will now use the first day of the week that you set with first_week_day as base (0).
Unless it is stated specifically, FirstWeekDay is set to 0 in these examples.
weekday( '1971-10-12' )
returns 'Tue' and 1
|weekday( '1971-10-12' , 6)||
returns 'Tue' and 2.
In this example we use Sunday (6) as the first day of the week.
SET FirstWeekDay = 6;
|returns 'Tue' and 2.|