proud Posted February 2, 2010 Share Posted February 2, 2010 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? Link to comment https://forums.phpfreaks.com/topic/190667-cant-insert-a-value-to-a-date-field/ Share on other sites More sharing options...
PFMaBiSmAd Posted February 2, 2010 Share Posted February 2, 2010 The correct format of a DATE field is YYYY-MM-DD Link to comment https://forums.phpfreaks.com/topic/190667-cant-insert-a-value-to-a-date-field/#findComment-1005527 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.