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.