title: timestamp update on oracle via perl dancer
body: <p>I am getting the following error while trying to update a timestamp on oracle database using per dancer.</p>
  
  <pre><code>ORA-01858: a non-numeric character was found where a numeric was expected.
  </code></pre>
  
  <p>The code:</p>
  
  <pre><code>   my $fmt = 'YYYY-MM-DD HH24:MI:SS:FF3';
     database-&gt;do("alter session set nls_timestamp_format = '$fmt'");
  
  
      my $time_start =params-&gt;{'start1'};#2014-04-29 10:21:42:037
  
      my $time_stop = params-&gt;{'stop1'};  #2014-04-29 10:42:08:355
      my $id = params-&gt;{'id'};
  
      my $timestart ="TO_TIMESTAMP('$time_start','YYYY-MM-DD HH24:MI:SS:FF3')";
      my $timestop ="TO_TIMESTAMP('$time_stop','YYYY-MM-DD HH24:MI:SS:FF3')";
      database-&gt;quick_update($table, {ID =&gt; $id}, {SBYS_START_TIME =&gt; $timestart, SBYS_STOP_TIME =&gt;$timestop});
  </code></pre>