title: php date() mysql datetime
body: <p>I want to use PHP to insert date into mysql datetime field.</p>
  
  <pre><code>$time = date('Y-m-d');
  
  mysql_query(INSERT INTO A (date) VALUE ('$time'));
  </code></pre>
  
  <p>Table A date column is datetime field. I want it shows 2011-01-24. But it always shows 2011-01-24 00:00:00. So my problem is how to remove the suffix "00:00:00".</p>