Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.22 KB | None | 0 0
  1. # Ayın ilk günün verir // 2011-02-01
  2. SELECT DATE_ADD(LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 30 DAY), INTERVAL 1 DAY);
  3. SELECT DATE_FORMAT(CURDATE(),'%Y-%m-01')
  4.  
  5. # Ayın Son Günü // 2011-02-28
  6. SELECT LAST_DAYS(CURDATE())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement