title: How to convert a double to two decimal places in netezza
body: <p>I have tried everything I could on Netezza! Here is what I've tried:</p>
  
  <ol>
  <li><p><code>SELECT 45/CAST(7 AS DOUBLE)</code> ---> 6.4285714285714 </p></li>
  <li><p>But I want results to be 6.43 so I tried <code>SELECT ROUND(45/CAST(7 AS DOUBLE), 2)</code> but get an error: <code>'NZOLEDB' failed with no error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21)</code>.</p></li>
  <li><p>Also tried <code>SELECT 45/CAST(7 AS DOUBLE) :: DECIMAL(5,2)</code>. Get same as error as in point 2 above.</p></li>
  </ol>
  
  <p>Could someone please assist! It's very frustrating.</p>