Page 1 of 1
problme in date adding
Posted: Sat May 20, 2006 3:43 am
by itsmani1
I am using mysql 4.0 and following query don't work on, is there any method that can do the same work.
Code: Select all
SELECT ADDDATE('2006-05-10', 14 ) as dat
Posted: Sat May 20, 2006 3:57 am
by timvw
http://dev.mysql.com/doc/refman/4.1/en/ ... tions.html
ADDDATE(date,INTERVAL expr type), ADDDATE(expr,days)
When invoked with the INTERVAL form of the second argument, ADDDATE() is a synonym for DATE_ADD(). The related function SUBDATE() is a synonym for DATE_SUB(). For information on the INTERVAL argument, see the discussion for DATE_ADD().
mysql> SELECT DATE_ADD('1998-01-02', INTERVAL 31 DAY);
-> '1998-02-02'
mysql> SELECT ADDDATE('1998-01-02', INTERVAL 31 DAY);
-> '1998-02-02'
As of MySQL 4.1.1, the second syntax is allowed. When invoked with the days form of the second argument, MySQL treats it as an integer number of days to be added to expr.
mysql> SELECT ADDDATE('1998-01-02', 31);]