title: I want to change Number format to date time format in cognos report studio in my query expression
body: <p>In report studio, I am query expression  where I want to change integer value coming directly from DB as 20151231 as one row of the date column. </p>
  
  <p>I want to change this column values in report studio as 31/12/2015 12:23:41 PM. I have used data format property also but it is not working. I need query for this.</p>