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: 12, rows affected: 0, absolute service time: 0,16 sec

latest | 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
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

λ

                                      .NET NoSQL database for rapid development