title: How query specific date with dbc.tablesV.LastAccessTimeStamp in Teradata
body: <p>I need a help to find how to cast timestamp for this case.
  I tried:</p>
  
  <pre><code>cast('2017-01-04 13:00:00' as timestamp(0) format'YYYY-MM-DDBHH:MI:SS')
  </code></pre>
  
  <p>The query is as follows:</p>
  
  <pre><code>`SELECT
    b.databasename,
    a.tablename,
    a.CreatorName,
    a.CreateTimeStamp,
    a.LastAccessTimeStamp,
    sum(currentperm)/(1024*1024) as tbsize
   FROM dbc.tablesV a
   INNER JOIN dbc.tablesizeV b
   ON a.tablename = b.tablename
   AND a.databasename=b.databasename
   WHERE a.databasename = 'tablea' 
   AND a.LastAccessTimeStamp = '2017-01-14 13:00:00'
   GROUP BY 1, 2, 3, 4, 5;`
  </code></pre>
  
  <p>I will appreciate any help.</p>