title: Log Parser2.2 TO_DATE & TO_TIMESTAMP conversion
body: <p>Just started using log parser 2.2, so please excuse me if this is too silly, but I am stuck at converting a string to timestamp.</p>
  
  <p>The following Query gives me an output of the date in string format from a log file</p>
  
  <pre><code>$&gt;logparser -i:textline -RTP:-1 "SELECT TOP 1 EXTRACT_SUFFIX(text,0,'TIMESTAMP') from 'C:\ptclmgrd.log' where text like '%TIMESTAMP%'"
  
  EXTRACT_SUFFIX(Text, 0, 'TIMESTAMP')
  ------------------------------------
   2/6/2015
  
  Statistics:
  -----------
  Elements processed: 951
  Elements output:    1
  Execution time:     0.03 seconds
  </code></pre>
  
  <p>I need to insert the above string in csv, or table but it should be in date format.</p>
  
  <p>If I try the following, the output is just <code>-</code>:</p>
  
  <pre><code>$&gt;logparser -i:textline -RTP:-1 "SELECT TOP 1 TO_TIMESTAMP(EXTRACT_SUFFIX(text,0,'TIMESTAMP'),'MM/dd/yyyy') from 'C:\ptclmgrd.log' where text like '%TIMESTAMP%'"
  
  TO_TIMESTAMP(EXTRACT_SUFFIX(Text, 0, 'TIMESTAMP'), 'MM/dd/yyyy')
  ----------------------------------------------------------------
  -
  
  Statistics:
  -----------
  Elements processed: 951
  Elements output:    1
  Execution time:     0.01 seconds
  </code></pre>
  
  <p>The log file entry that I am trying to parse is something like: </p>
  
  <pre><code>3:12:40 (lmgrd) TIMESTAMP 2/6/2015
  </code></pre>
  
  <p>Any idea what's wrong? I am expecting the output as same string in date format.
  I also tried <code>M/d/YYYY</code> but getting same output.</p>