Advertisement
Guest User

Untitled

a guest
Jul 25th, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT LAST_DAY(DATE_ADD(NOW(), INTERVAL 12-MONTH(NOW()) MONTH)); //It shows this year (2017)'s last day. ==> 2017-12-31
  2.  
  3. ++++This Year++++ | ++++Last Year's Last Day++++
  4.  
  5. 2017 | 2016-12-31
  6. 2018 | 2017-12-31
  7. 2019 | 2018-12-31
  8. 2020 | 2019-12-31
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement