title: Querying using the datepart from a time stamp in a pass-through Proc SQL
body: <p>I am trying to use the date part of a time-stamp in my where query in a db2 pass-through proc SQL code below. I tried using date and datepart functions but it wont work with this format. Does anyone know the name of the function to use in the same code below? </p>
  
  <pre><code>PROC SQL; 
     connect to db2(ssid=smtng); 
       select *  from connection to db2 
           (select *  
               from ATable 
            where DATEPART(timestamp) &gt; '12/01/2013'
     FOR READ ONLY WITH UR
      );
  DISCONNECT FROM DB2;
  QUIT; 
  </code></pre>