Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. SET @start_date = 2017-12-20 00:00:00
  2. SET @end_date = 2019-04-30 23:59:59
  3. SET @type = 'Q3'
  4.  
  5. period | num_of_days
  6. Q3_17_18 | 71 (dec 2017 from start_date + jan, feb 2018 = 12+31+28)
  7. Q3_18_19 | 90 (dec 2018 + jan, feb 2019 = 31+31+28)
  8.  
  9. datetime_value | value |
  10. 2018-04-21 00:01:00 | 100 |
  11. 2018-04-21 00:02:00 | 400 |
  12. 2018-04-21 00:03:00 | 200 |
  13. ...
  14. 2019-02-03 00:16:00 | 100 |
  15. 2018-04-21 00:17:00 | 500 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement