title: Inserting datetime in MSSQL from Coldfusion
body: <p>I am trying to insert <code>NOW</code> into a MySQL table. Something like:</p>
  
  <pre><code>&lt;cfset datatime = CREATEODBCDATETIME( Now() ) /&gt;
  
  &lt;cfquery name="qInsert" datasource="#dbanme#" &gt;
     INSERT INTO TableName(....,date_created, date_modified)
     VALUES(...,'#datatime#', '#datatime#')
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>But I am getting the following error:</p>
  
  <blockquote>
    <p><em>Invalid JDBC timestamp escape</em></p>
  </blockquote>
  
  <p>Any help?</p>