WEEKDAY: Returning the Day of the Week

How to:

Given a date or date-time value, WEEKDAY returns an integer from 1 (Monday) to 7 (Sunday) representing the day of the week for that date.


Top of page

x
Syntax: How to Return the Day of the Week
WEEKDAY(arg)

where:

arg

Date or date-time

Is the input date or date-time value.



Example: Returning the Day of the Week

WEEKDAY returns the day of the week for each birth date, where 1 represents Monday and 7 represents Sunday:

WEEKDAY(DATE_OF_BIRTH)

For 1993/03/27, the result is 6 (Saturday).


iWay Software