Interval

[thoand]

Hi,
Is it possible to update a date field with 1 Year and 4 months

eg.

... SET my_date = NOW()+INTERVAL 1 YEAR + INTERVAL 4 MONTH WHERE ....

Thanks in advance for tips

regards,
Thomas A

[jim_keller]

Hey Thomas,
Try this:
SET myDate = date_add( NOW(), INTERVAL '1-4' YEAR_MONTH );

There is plenty of information on date_add and other date/time functions in the mySQL manual at :

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

Hope this helps!

Jim Keller
http://jim.centerfuse.net/projects/

[Sxooter]

Should be as simple as:

SET my_date = NOW()+INTERVAL '1 YEAR 4 MONTHS' WHERE