What's wrong with (NOW(), INTERVAL 2 DAY)?

Question

What's wrong with (NOW(), INTERVAL 2 DAY)?

It would seem that simple code

$sqld = "DELETE FROM Funders WHERE reg_date < (NOW(), INTERVAL 2 DAY)";

if ($conn->query($sqld) === TRUE) {
 echo "Record deleted successfully";
} else {
 echo "Error deleting record:" . $conn->error;
}

Error:

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 ')'

What am I doing wrong?

Corine_Beier asked July 8th 19 at 15:54

Related questions

More answers about "What's wrong with (NOW(), INTERVAL 2 DAY)?"

1 answer

aniya answered on · Answer 1 · 2019-07-08T15:56:59.950Z

aniya answered on July 8th 19 at 15:56

Function you forgot to write. SUBDATE(), judging by the context, or some other.

Even if I have the date stored in the timestamp? - Corine_Beier commented on July 8th 19 at 15:59

Who cares how you have stored the date, if you have a syntax error? DBMS just can't recognize what you want from him. - aniya commented on July 8th 19 at 16:02

: what error is that? ) - Corine_Beier commented on July 8th 19 at 16:05