Roger Baklund: > * Philipp Sutter > > I have a Mysql-table with a field of type double. when i retrieve > > very small > > numbers from this table I get them allways in a scientific notation: > > i.e. 8.34e-05. what i have to do, that i get the same number in normal > > notation: 0.0000834? > > See the FORMAT() function: > > <URL: http://www.mysql.com/doc/en/Miscellaneous_functions.html > > > -- > Roger
format() has two disadvantages: 1) format will round the number. i can't round the numbers. 2) format(number,13) will get i.e. 0.0000834000000. i do not want the ending zeros. is there an other way to get only the number i.e. 0.0000834. philipp --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php