在mysql中更新日期

I have a calendar and i want to insert selected date into mysql database using javascript and php but I'm getting 0000-00-00 in my database row

function monthClick(e) {
clickedDays += 1;
$(e).toggleClass("clicked");
startDateIndex = parseInt($(e).attr('id').split('-')[1]);
startDate = new Date(currentYear, currentMonth, startDateIndex);
id = 160;
var urlU = "id=" + id + "&dateC=" + startDate;
$.ajax({
    url : "http://localhost/dateC.php",
    type : "GET",
    cache : false,
    data : urlU,
    success : function(response) {
        alert(response);
    }

});
}

and here is my php file :

    <?php
    $servername = "localhost";
     $username = "root";
$password = "";
$dbname = "database";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
 $id=$_GET['id'];
 $dateDebutC=$_GET['dateDebutC'];
// Check connection²M
if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
}
$sql = "UPDATE normal  SET dateC ='$dateC' WHERE id='$id'";
if ($conn->query($sql)) {
       echo 'DB Update successful';
   }
   else {
       echo 'DB Update failed';
   }
$conn->close();
?>

mysql requires "YY-MM-DD" fromat. Convert your date in "2017-04-17" format before saving into database table, it will work fine.

You should encode the date before pass it through ajax parameters