为什么这个MySQL Update查询不起作用？

Here is my code for updating the date field for all records that have the field WorkoutID = $currentWorkoutID. When I run the query the dates change to 0000-00-00 and not to the current date. How can I fix this? Btw DB::getInstance() executes the query. I think something is wrong with the actual query?

$currentWorkoutID = $_SESSION['GlobalWorkoutID'];
echo $currentWorkoutID;

$date = date("y/m/d");
echo $date;

$sql = "UPDATE workout SET Date = ".$date." WHERE WorkoutID = ".$currentWorkoutID."";
DB::getInstance()->query($sql);

include single quotes ' for date

$sql = "UPDATE workout SET Date = '".$date."'  WHERE WorkoutID = ".$currentWorkoutID."";
                                  ^         ^

Try this

$sql = "UPDATE workout SET `Date` = '".$date."' WHERE WorkoutID = ".$currentWorkoutID."";

Because date is a reserved keyword

i agrre with the answer $sql = "UPDATE workout SET Date = '".$date."' WHERE WorkoutID = ".$currentWorkoutID."";

because maybe the type of Date is String , hope to help you,thank you