WHERE myDate BETWEEN DAYOFWEEK (2) AND DAYOFWEEK(1)

What is the right syntax to get the Sum of a certain field between monday 00.01 and sunday 00.00, i.e.


SELECT SUM(fieldName)
   FROM  tableName
WHERE  myDate BETWEEN DAYOFWEEK(monday) AND DAYOFWEEK(sunday)

As you see do I not need this for a given week, but just as a general query. Thank you in advance.

Hi. This is solved. Instead of the DAYOFWEEK() function I used the WEEKDAY() function, i.e.


WHERE WEEKDAY(datum) >= 0
     AND WEEKDAY(datum) <= 6

you can go ahead and remove that altogether

0 through 6 are the only possible values