title: Datetime's NOW() function does not work with PDO-MYSQL prepared statements?
body: <p>I have a database table <code>timetable</code> with a <code>DATETIME</code> field called <code>created_on</code>.</p>
  
  <pre><code>created_on DATETIME,
  notes VARCHAR(255) NOT NULL
  </code></pre>
  
  <p>I use the <code>NOW()</code> function to insert the current time through PDO prepared statements.</p>
  
  <pre><code>INSERT INTO timetable(created_on, note)
  VALUES(?, ?);
  </code></pre>
  
  <p>So after binding the values and executing the prepared statement...</p>
  
  <pre><code>$notes ="This is a note...";
  $values =array("NOW()", $notes);
  $stm-&gt;execute($values);
  </code></pre>
  
  <p>... the <code>notes</code> column in the MySQL table writes the expected data but the <code>created_on</code> column produces...</p>
  
  <pre><code>0000-00-00 00:00:00 
  </code></pre>
  
  <p>I don't want to use the Unix epoch timestamp. So how do I get <code>DATETIME</code> in the  <code>NOW()</code> function to work?</p>