title: Netezza SQL - give a parameter
body: <pre><code>SELECT to_char(START_D,???)
  </code></pre>
  
  <p>The issue I have above is that I can't seem to find the right parameter for the above to work.
  The date is numeric e.g 1102. I want to turn this into a character.</p>
  
  <p>Actually even better is to turn the numeric field to 11/02, which is Day/Month. The reason why I want to turn it into character is that it outputs without the zeros in front. e.g 712 instead of 0712.</p>
  
  <p>Thanks in advance!</p>