SHARE
TWEET

Untitled

a guest Jun 19th, 2019 69 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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   |
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top