title: query to return specific date from teradata timestamp(6)
body: <p>How can i search for a particular date for eg: '2013-10-22' from teradata timestamp(6) field?</p>
  
  <pre><code>sel * from table A
  where date = '2013-10-22';
  </code></pre>
  
  <p>I tried the above query which is throwing error. Please help!</p>