advanced code snippet search

Posted By

assbach on 02/21/07


Tagged

mysql date


Versions (?)

now plus 20 years

 / Published in: SQL
 

useful if a "valid until" should have an exact ( in this case far future ) value.

Expand | Embed | Plain Text 
  1. SELECT ADDDATE( NOW(), INTERVAL 20 YEAR )

Report this snippet  

You need to login to post a comment.