Hi,

I am trying select field / 10000 as Number from table1 where id = 1;
I don't want any rounding taking place, but MySQL is currently doing it.
How can I ask for a specific number of digits with division?

The field contains 1234.5678, MySQL returns 1234.57, don't want that!

Thanks,

Cory Twibell
Lockheed Martin Space Systems Company
Electronic Combat Development Systems
[EMAIL PROTECTED]
(303) 971-3184


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to