title: Teradata format string for converting string to timestamp(6)
body: <p>I have a columnn of timestamps stored as text with no spaces, hyphens, slashes or decimal points, e.g. <code>20140328160335880258</code>. I want to convert this text to a timestamp in Teradata (v15).</p>
  
  <p>If cut off the microseconds, the following works:</p>
  
  <pre><code>SELECT CAST('20140328160335' AS TIMESTAMP(0) FORMAT 'yyyymmddhhmiss') 
  </code></pre>
  
  <p>However, I can't find a format string that allows the partial seconds to be included in the timestamp:</p>
  
  <pre><code>SELECT CAST('20140328160335880258' AS TIMESTAMP(6) FORMAT 'yyyymmddhhmiss') 
  &gt; SELECT Failed. 6760: Invalid timestamp
  
  SELECT CAST('20140328160335880258' AS TIMESTAMP(6) FORMAT 'yyyymmddhhmissssssss') 
  &gt; SELECT Failed. 3350: Invalid FORMAT string
  </code></pre>
  
  <p>I've tried <code>'yyyymmddhhmiss.ssssss'</code>, <code>'yyyymmddhhmiss.s(6)'</code>, <code>'yyyymmddhhmisss(6)'</code> and <code>'yyyymmddhhmissffffff'</code>, but all are invalid.</p>
  
  <p>Is the only option to insert a decimal point into the text version of the timestamps?</p>