how to display a weekday(set it to zero) of datepart function , Sql Server

how to display a weekday(set it to zero) of datepart function

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 14, rows affected: 13, absolute service time: 0,17 sec

edit mode | history

  
day
storeid
num_sales

1
Monday
3
90

2
Tuesday
3
70

3
Wednesday
3
20

4
Thursday
3
60

5
Friday
3
96

6
Saturday
3
98

7
Sunday
3
200

8
Monday
4
90

9
Tuesday
4
70

10
Wednesday
4
20

11
Thursday
4
60

12
Friday
4
96

13
Saturday
4
98

14
Sunday
4
0

λ

                                      .NET NoSQL database for rapid development