title: How to use MySQL functions when building a query with Zend/PDO
body: <p>I'm using Zend Framework with the PDO MySQL adapter and I want to use a function in my insert statement. Basically, the SQL I want to generate is this:</p>
  
  <pre><code>INSERT INTO `myTable` (`leftId`, `rightId`, `date`) VALUES ($left, $right, NOW())
  </code></pre>
  
  <p>This is the code in my Model:</p>
  
  <pre><code>$data = array(
      "leftId" =&gt; $left,
      "rightId" =&gt; $right,
      "date" =&gt; "NOW()"
  );
  
  $this-&gt;insert($data);
  </code></pre>
  
  <p>This tries to insert <code>"NOW()"</code> rather than <code>NOW()</code>:</p>
  
  <blockquote>
    <p>General error: 1292 Incorrect datetime value: 'NOW()' for column 'date' at row 1</p>
  </blockquote>
  
  <p>How do I go about this?</p>