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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.