WEEKDAY function

Evaluates a date expression and returns the day of the week as an INTEGER value from 1 (Sunday) to 7 (Saturday) for that date.

Syntax 

 

WEEKDAY ( date )

 

WEEKDAY ( datetime-expression )

date

A date expression for which you want the day of the week.

datetime-expression

An expression that evaluates to a DATETIME or DATETIME-TZ. The WEEKDAY function returns the weekday of the date part of the DATETIME or DATETIME-TZ value.

Example 

This procedure tells you the day of the week that you were born and how many days old you are:

 

r-wkday.p

DEFINE VARIABLE birth-date AS DATE      NO-UNDO LABEL "Birth Date". DEFINE VARIABLE daynum     AS INTEGER   NO-UNDO. DEFINE VARIABLE daylist    AS CHARACTER NO-UNDO FORMAT "x(9)" INITIAL "Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday". DEFINE VARIABLE dayname    AS CHARACTER NO-UNDO LABEL "Day You Were Born". DEFINE VARIABLE daysold    AS INTEGER   NO-UNDO LABEL "Days Since You Were Born".   REPEAT: SET birth-date.   ASSIGN     daynum  = WEEKDAY(birth-date)     dayname = ENTRY(daynum, daylist)     daysold = TODAY - birth-date.   DISPLAY dayname daysold. END.

See also 

ADD-INTERVAL function, DATE function, DATE-FORMAT attribute, DATETIME function, DATETIME-TZ function, DAY function, ETIME function, INTERVAL function, ISO-DATE function, MONTH function, MTIME function, NOW function, TIME function, TIME-SOURCE attribute, TIMEZONE function, TODAY function, YEAR function, YEAR-OFFSET attribute