Hello Everybody !
In my table I have fixed(8,2) columns !
In my application I need all values in an fixed format nnnnnn.nn
I tried select fixed(a,5,2),fixed(b,5,2) from ...
But the result show only 2 decimal places if the value has decimal
places ?
5 5.5 7.77 3
I need
5.00 5.50 7.77 3.00
Any help welcomed
Albert
'''''
'''''''''
(0 0)
+---------oOO-----------(_)------------------------------+
| Tel: 0541/5841-868 |
| Fax: 0541/5841-869 |
| Mail: mailto:[EMAIL PROTECTED] |
| Internet: http://www.piepenbrock.de |
+--------------------------------------oOO----------------+
|__|__|
|| ||
ooO Ooo
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
