title: insert a datetime variable in a timestamp field
body: <p>I have a problem when I try to insert a date (Now()) in a timestamp declared BigQuery table field.
  I code in ColdFusion language. In this language, the function Now() returns a datetime of this format: <code>{ts '2014-05-05 15:32:06'}</code> </p>
  
  <p>This is my BigQuery table schema: <code>Name:string,Date:Timestamp</code></p>
  
  <p>This is my code trying to insert a row: </p>
  
  <pre><code>&lt;cfset row.set("Name","Alex")&gt;
  &lt;cfset row.set("Date", now())&gt;
  </code></pre>
  
  <p>Since the schema in Google BigQuery API does not support date types other than timestamp what should I do to convert the date given by the function now() (in ColdFusion) to be able to insert my row?</p>
  
  <p>Thank you all for your answers, 
  if we have to pass a string variable as a second argument for the method set we can also write: </p>
  
  <pre><code>    &lt;cfset row.set('Date',mid("#now()#",6,19))&gt; 
  </code></pre>
  
  <p>to retreive a string of (yyyy-mm-dd HH:MM:SS)</p>