title: DB2: converting date values to varchar
body: <p>I am new to databases, in fact this is first time.</p>
  
  <p>I want to select the date column from a table and the date to be printed as an output in some given format, like is there a way i can specify the format of output of this conversion. </p>
  
  <p>eg:</p>
  
  <pre><code>date: 01/01/2011
  </code></pre>
  
  <p>output :</p>
  
  <pre><code>Jan 1 2011
  </code></pre>
  
  <p>or</p>
  
  <pre><code>1st January 2011
  </code></pre>
  
  <p>Is there a function or way to do so? My guess is there must be?</p>
  
  <p>Thanks</p>