title: DB2 The syntax of the string representation of a datetime value is incorrect
body: <p>We have a staging table that's used to load raw data from our suppliers. </p>
  
  <p>One column is used to capture a time-stamp but its data-type is varchar(265). Data's dirty: about 40% of the time, there is garbage data, otherwise time-stamp data like this</p>
  
  <pre><code>2011/11/15 20:58:48.041 
  </code></pre>
  
  <p>I have to create a report that filters some dates/timestamps out that column but where I try to cast it, I get an error:</p>
  
  <pre><code>db2 =&gt; select cast(loadedon as timestamp) from automation
  
  1
  --------------------------
  SQL0180N  The syntax of the string representation of a datetime value is incorrect.  SQLSTATE=22007
  </code></pre>
  
  <p>What do I need to do in order to parse/cast the timestamp string?</p>