WEEKDAY

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
      X

This function is used to extract the numeric value (1-7) of the day of the week. The format appears below:

WEEKDAY(date)

For example:

WEEKDAY(tuesday) = 2