function Get start and end date for each week in month, Sql Server

function Get start and end date for each week in month

Language: Layout:

View schema
Execution time: 0,03 sec, rows selected: 11, rows affected: 0, absolute service time: 0,16 sec

edit mode | history

  
WeekOfMonth
Week
WeekStart
WeekEnd

1
1
1
01.01.2017 00:00:00
01.01.2017 00:00:00

2
2
2
02.01.2017 00:00:00
08.01.2017 00:00:00

3
3
3
09.01.2017 00:00:00
15.01.2017 00:00:00

4
4
4
16.01.2017 00:00:00
22.01.2017 00:00:00

5
5
5
23.01.2017 00:00:00
29.01.2017 00:00:00

6
6
6
30.01.2017 00:00:00
31.01.2017 00:00:00


  
WeekOfMonth
Week
WeekStart
WeekEnd

1
1
6
01.02.2017 00:00:00
05.02.2017 00:00:00

2
2
7
06.02.2017 00:00:00
12.02.2017 00:00:00

3
3
8
13.02.2017 00:00:00
19.02.2017 00:00:00

4
4
9
20.02.2017 00:00:00
26.02.2017 00:00:00

5
5
10
27.02.2017 00:00:00
28.02.2017 00:00:00

λ

                                      .NET NoSQL database for rapid development