ODD-BALL start-finish dates over date range, MySQL - rextester

Run Code | API | Code Wall | Misc | Feedback | Login | Theme | Privacy | Patreon

ODD-BALL start-finish dates over date range

Language: Layout:


absolute service time: 0,32 sec

edit mode | history

  
period_start_dt
period_end_dt

1
04.01.2017 00:00:00
04.02.2017 00:00:00

2
04.02.2017 00:00:00
04.03.2017 00:00:00

3
04.03.2017 00:00:00
04.04.2017 00:00:00

4
04.04.2017 00:00:00
04.05.2017 00:00:00

5
04.05.2017 00:00:00
04.06.2017 00:00:00

6
04.06.2017 00:00:00
04.07.2017 00:00:00

7
04.07.2017 00:00:00
04.08.2017 00:00:00

8
04.08.2017 00:00:00
04.09.2017 00:00:00

9
04.09.2017 00:00:00
04.10.2017 00:00:00

10
04.10.2017 00:00:00
04.11.2017 00:00:00

11
04.11.2017 00:00:00
04.12.2017 00:00:00

12
04.12.2017 00:00:00
04.01.2018 00:00:00

λ

                                      .NET NoSQL database for rapid development