title: DB2 Date format
body: <p>I just want to format current date into <code>yyyymmdd</code> in DB2.</p>
  
  <p>I see the date formats available, but how can I use them?</p>
  
  <p><a href="http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.intro%2Fsrc%2Ftpc%2Fdb2z_datetimetimestamp.htm" rel="noreferrer">http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.intro%2Fsrc%2Ftpc%2Fdb2z_datetimetimestamp.htm</a></p>
  
  <pre><code>SELECT CURDATE() FROM SYSIBM.SYSDUMMY1;
  </code></pre>
  
  <p>I dont see any straightforward way to use the above listed formats.</p>
  
  <p>Any suggestion?</p>