MySQL: DATE_ADD

mysql dateadd
John Kurlak picture John Kurlak · Jul 15, 2009 · Viewed 15.5k times · Source

Is there a difference between:

SELECT DATE_ADD('2005-01-01', INTERVAL 3 MONTH);

and

SELECT '2005-01-01' + INTERVAL 3 MONTH;

Answer

chaos picture chaos · Jul 15, 2009

No, they're the same.

Related questions

MySQL - DATE_ADD month interval

I face a problem with the function DATE_ADD in MySQL. My request looks like this : SELECT * FROM mydb WHERE creationdate BETWEEN "2011-01-01" AND DATE_ADD("2011-01-01", INTERVAL 6 MONTH) GROUP BY MONTH(creationdate) The problem is that, in …

Read More
Using DATE_ADD with a Column Name as the Interval Value

I have a table which contains products, a start date and an interval value : product_name start_date expiry_period Domain Registration (1 Year) 2013-12-08 00:00:00 1 Year Domain Registration (1 Year) 2013-12-01 00:00:00 1 Year Website Hosting (Bronze) 2013-12-19 00:00:00 1 Year Website Hosting (…

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More