I think what you are missing though is that the point about the different datatypes is that you should use the smallest datatype that makes sense in order to keep...

I like your method Tomasz, it leads to much cleaner looking queries.

However, your code doesn't quite work.

In particular you are subtracting 1 from the day of the week twice

This...