Guest User

Untitled

a guest
Aug 19th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. MySQL add days to a date
  2. UPDATE classes
  3. SET
  4. date = date + 1
  5. where id = 161
  6.  
  7. SELECT DATE_ADD(`your_field_name`, INTERVAL 2 DAY);
  8.  
  9. UPDATE classes
  10. SET `date` = DATE_ADD(`date` , INTERVAL 2 DAY);
  11. WHERE `id` = 161
  12.  
  13. UPDATE table SET nameofdatefield = ADDDATE(nameofdatefield, 2) WHERE ...
  14.  
  15. update tablename set coldate=DATE_ADD(coldate, INTERVAL 2 DAY)
  16.  
  17. SELECT DATE_ADD(CURDATE(), INTERVAL 2 DAY)
  18.  
  19. UPDATE classes
  20. SET `date` = DATE_ADD(`date`, INTERVAL 2 DAY)
  21. WHERE id = 161
  22.  
  23. DATE_ADD(FROM_DATE_HERE, INTERVAL INTERVAL_TIME_HERE DAY)
  24.  
  25. DATE_ADD(NOW(), INTERVAL -1 DAY) for deducting 1 DAY from current Day
  26. DATE_ADD(NOW(), INTERVAL 2 DAY) for adding 2 Days
  27.  
  28. UPDATE classes WHERE date=(DATE_ADD(date, INTERVAL 1 DAY)) WHERE id=161
  29.  
  30. SET date = DATE_ADD( fieldname, INTERVAL 2 DAY )
Add Comment
Please, Sign In to add comment