0 Replies Latest reply: Jan 25, 2013 1:36 AM by rameshchandra RSS

    Data retrieval in non-scientific notation from Netezza database

    rameshchandra
      Hi,

      I have a requirement where my BPEL service fetches data from Netezza database. In the database, there is a field which is of type numeric(16,8) and holds values say '0.00000000'. The select query on the table rerieves data in its scientific notation as '0E-8'.
      Please let me know how to retrieve its value in the form of non-scientific notation.
      Thanks in advance.

      Regards,
      Sitara