DB2 number formatting ...

DB2 number formatting ...

 

  

Hi all,

Can someone please tell me how do I format these numbers under DB2?

+1.02400000000000E+006 +8.35584000000000E+005 +1.24184000000000E+004

That is, don't want to see exponential output or what function to use to format
these when doing a SELECT. Thanks in advance.




DB2 & UDB email list listserv db2-l LazyDBA home page