title: Convert dd-mon-yy string to date in DB2
body: <p>in DB2 I've got date values stored as varchar in the form <code>'DD-Mon-YY'</code> (e.g. 25-Jun-13). I'd like to convert these into DB2 compatible date formats using the <code>TO_DATE</code> function but every date conversion format I've tried gives me an error.</p>
  
  <p>e.g. I've tried <code>TO_DATE('25-Jun-13', 'YYYYMMDD')</code> and <code>TO_DATE('25-Jun-13', DDMMYYYY)</code> and I always get something like <code>"25-Jun-13" cannot be interpreted using format string "DDMMYYYY" for the TIMESTAMP_FORMAT function.</code></p>
  
  <p>Does anyone know if there is a format string that I can use? </p>