take a look DOW() function.
According to Help "Returns a numeric day-of-the-week value from a Date or DateTime expression"
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.