INSERT INTO SQL DATEADD Yesterday

mysql dateadd
number5 picture number5 · Nov 21, 2012 · Viewed 9.7k times · Source

I want to use PHP and MySQL to INSERT the the day of Yesterday. So my idea was:

INTO chartValues SET timestamp='1353369600', `datetime`=DATEADD(d,-1,GETDATE())

But its not working:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO chartValues SET timestamp='1353369600', datetime=DATEADD(d,-1,GETDATE())' at line 1

Thanks in advance

Answer

Kermit picture Kermit · Nov 21, 2012

DATEADD and GETDATE() are T-SQL functions used in SQL Server.

You want to use DATE_ADD() or DATE_SUB() with NOW()

INSERT INTO chartValues SET timestamp='1353369600', `datetime`= DATE_SUB(NOW(), INTERVAL 1 DAY)

Reference

DATE_SUB(date, INTERVAL expr unit)

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
MySQL: DATE_ADD

Is there a difference between: SELECT DATE_ADD('2005-01-01', INTERVAL 3 MONTH); and SELECT '2005-01-01' + INTERVAL 3 MONTH;

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