title: Date functions trim off timestamp in DB2
body: <p>Is there a way to trim off the timestamp in a DB2 date function?</p>
  
  <p>Have DB2 select statement where I'mm selecting a date form the databease and saving it to a variable. I then use that variable as a parameter for another db2 select by adding 30days to it but I don't think it agrees with the timestamp that it is adding to the end.</p>
  
  <pre><code>Select business_date From DB2INST1.BusDate Where key = 0
  </code></pre>
  
  <p>There is no timestamp in the database for this date but its adding '12:00:00AM' to the end</p>
  
  <p>it saves this select into a variable and I use it in another select here</p>
  
  <pre><code>where expirdate &gt; (DATE(@BusDate) + 30 DAYS)
  </code></pre>
  
  <p>I get this error:</p>
  
  <blockquote>
    <p>{"ERROR [428F5] [IBM][DB2/AIX64] SQL0245N  The invocation of routine \"DATE\" is ambiguous. The argument in position \"1\" does not have a best fit."} System.Exception {IBM.Data.DB2.DB2Exception}</p>
  </blockquote>