Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @start_date = 2017-12-20 00:00:00
- SET @end_date = 2019-04-30 23:59:59
- SET @type = 'Q3'
- period | num_of_days
- Q3_17_18 | 71 (dec 2017 from start_date + jan, feb 2018 = 12+31+28)
- Q3_18_19 | 90 (dec 2018 + jan, feb 2019 = 31+31+28)
- datetime_value | value |
- 2018-04-21 00:01:00 | 100 |
- 2018-04-21 00:02:00 | 400 |
- 2018-04-21 00:03:00 | 200 |
- ...
- 2019-02-03 00:16:00 | 100 |
- 2018-04-21 00:17:00 | 500 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement