Can't insert a value to a date field

[proud]

I have a table called time with 2 fields: id(Int), and date(Date)..

 

Now when I use this query to insert the following date value to the table:

 

<?php

include( 'conn.php' );


$borrow_date = date("d-m-Y");  // current date

echo $borrow_date;  

$sql= mysql_query("insert into time (id,date) values('','$borrow_date')") or die (mysql_error());

?>

 

 

The new value of id is (1), but the new value of date is (0000-00-00), when it is supposed to be (02-02-2010)..

 

Does any one know why?

[PFMaBiSmAd]

The correct format of a DATE field is YYYY-MM-DD