title: Convert a Date field into Week Number in IBM DB2
body: <p>I have a Date field <strong>(CHAR Datatype</strong>) which has values in this format: YYYYMMDD.</p>
  
  <p>For example 20140729.</p>
  
  <p>I want to convert it into a Weeknumber in format YYYYWKNO</p>
  
  <p>For example, the result would be 201432. </p>
  
  <p>How this can be done in <strong>IBM DB2?</strong> </p>