* Karam Chand > I have a column with double values like - > > .000001 > .000002 > .000003 > > Well...its sounds ridiculous but i do have data like > that :) > > I am using C API to get the resultset, but the data is > resturned as ( also with mysql client which uses C API > ). > > | 1e-006 | > | 2e-006 | > | 3e-006 | > | 4e-006 | > | 5e-006 | > | 6e-006 | > | 8 | > | 8e-006 | > > Is there any way wherein I can get data like .000001, > .000002 etc.
Maybe the FORMAT() function will do what you want: <URL: http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1391 > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
