Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I change the precision of float values displayed through isql?

April 26, 2017Float isql precision values

0

Posted

How can I change the precision of float values displayed through isql?

1 Answer

0

Posted

By default, isql displays only 6 digits of float or real data after the decimal point, rounding off the remainder. You can change the precision of display for float values in isql by using the str function. Using the str function documented in the Sybase Adaptive Server Enterprise Reference Manual, you can display more digits as: 1> select str(floatcol, length1, length2) from 2> go where length1 is the total number of characters to return, including the decimal point, blank spaces, and digits to the right and left of the decimal, and where length2 is the number of digits to the right of the decimal point.