title: Converting a string to a date in DB2
body: <p>I am working with a DB2 database for the first time.</p>
  
  <p>I am trying to work with DB2 dates, but the data is stored as a string in the DB2 database.</p>
  
  <p>I want to convert this date-string into an actual date, preferably dropping off time because I want all transactions between 1 Jan 2011 and 26 Jan 2011.</p>
  
  <p>So essentially, I want this MS SQL statement in DB2 magic...</p>
  
  <pre><code>CONVERT(datetime,SETTLEMENTDATE.VALUE,103)
  </code></pre>
  
  <p>For background, I have got as far as</p>
  
  <pre><code>CAST(SETTLEMENTDATE.VALUE, DATE)
  </code></pre>
  
  <p>AND</p>
  
  <pre><code>DATE(SETTLEMENTDATE.VALUE)
  </code></pre>
  
  <p>But I need the expert knowledge of a DB2 whizzkid!</p>
  
  <p>Thanks</p>