Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM days:
- ID_OTHERTABLE DATE_FROM DATE_TO SOME_INFO
- 1 2020-01-05 00:00:00.0 2020-01-06 00:00:00.0 hello
- 1 2020-01-06 00:00:00.0 2020-01-07 00:00:00.0 hello
- 1 2020-01-07 00:00:00.0 2020-01-08 00:00:00.0 hello
- 1 2020-01-10 00:00:00.0 2020-01-11 00:00:00.0 hello
- 1 2020-01-11 00:00:00.0 2020-01-12 00:00:00.0 hello
- 1 2020-01-12 00:00:00.0 2020-01-13 00:00:00.0 hello
- ---
- SELECT * FROM days_before:
- ID_OTHERTABLE DATE_FROM DATE_TO SOME_INFO
- 1 2020-01-01 00:00:00.0 2020-01-02 00:00:00.0 hello
- 1 2020-01-02 00:00:00.0 2020-01-03 00:00:00.0 hello
- 1 2020-01-03 00:00:00.0 2020-01-04 00:00:00.0 hello
- 1 2020-01-04 00:00:00.0 2020-01-05 00:00:00.0 hello
- ---
- SELECT * FROM days_after:
- ID_OTHERTABLE DATE_FROM DATE_TO SOME_INFO
- 1 2020-01-13 00:00:00.0 2020-01-14 00:00:00.0 hello
- 1 2020-01-14 00:00:00.0 2020-01-15 00:00:00.0 hello
- 1 2020-01-15 00:00:00.0 2020-01-16 00:00:00.0 hello
- 1 2020-01-16 00:00:00.0 2020-01-17 00:00:00.0 hello
- 1 2020-01-17 00:00:00.0 2020-01-18 00:00:00.0 hello
- 1 2020-01-18 00:00:00.0 2020-01-19 00:00:00.0 hello
- 1 2020-01-19 00:00:00.0 2020-01-20 00:00:00.0 hello
- 1 2020-01-20 00:00:00.0 2020-01-21 00:00:00.0 hello
- 1 2020-01-21 00:00:00.0 2020-01-22 00:00:00.0 hello
- 1 2020-01-22 00:00:00.0 2020-01-23 00:00:00.0 hello
- 1 2020-01-23 00:00:00.0 2020-01-24 00:00:00.0 hello
- 1 2020-01-24 00:00:00.0 2020-01-25 00:00:00.0 hello
- 1 2020-01-25 00:00:00.0 2020-01-26 00:00:00.0 hello
- 1 2020-01-26 00:00:00.0 2020-01-27 00:00:00.0 hello
- 1 2020-01-27 00:00:00.0 2020-01-28 00:00:00.0 hello
- 1 2020-01-28 00:00:00.0 2020-01-29 00:00:00.0 hello
- 1 2020-01-29 00:00:00.0 2020-01-30 00:00:00.0 hello
- 1 2020-01-30 00:00:00.0 2020-01-31 00:00:00.0 hello
- 1 2020-01-31 00:00:00.0 2020-02-01 00:00:00.0 hello
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
