How to correctly add a date to a table entry?

Question

PHP

The following error occurs when trying to create a record with data of type date:

Uncaught exception: 'PDOException'</p><p>Message: 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: ':end' for column 'timedate' at row 1'

The piece of code that is being executed:

$date = new \DateTime(date('Y-m-d'));
$date->add(new \DateInterval('P'.$period.'D'));
$endDate =$date->format('Y-m-d');

$status = 1;
$pdo = static::getDB();
$query = $pdo->prepare("INSERT INTO Invites (invite,timedate,status) VALUES (':code', ':end',':status')");
$query->bindParam(':code', $code, \PDO::PARAM_INT);
$query->bindParam(':end', $endDate, \PDO::PARAM_STR);
$query->bindParam(':status', $status, \PDO::PARAM_INT);
$query->execute();

The date is displayed in the required format (as in the database): 2018-05-10. What could be causing the problem?
PS I looked around stackoverflow with similar problems, I did not find a working solution.

Answer 1

Remove the quotes from the query. They are like horseshoes on a cow.
VALUES (:code, :end,:status)