How can I change my 1st weekday?

It's MySQL

Hi Sean,

Yip thanks I do realize that, but luckily I am using an input for that only allows values 0,1,2,3 to be captured. Hence why I used the case statement...

Thanks, I did try that, but because my CASE statement was in a nested query, it didn't work... I managed to get it working...

Here's how:

SELECT

SCH.column1

, ...