title: Netezza SQL syntax to convert numeric YYYYMMDD format into date
body: <p>We have a Netezza table that contains dates stored in a numeric YYYYMMDD format (eg 20090731).</p>
  
  <p>What is the best Netezza syntax to use to convert this into date format?</p>
  
  <p>eg </p>
  
  <pre><code>SELECT somefunction(20090731) as NZDATE
  </code></pre>
  
  <p>?</p>