Hello It formats the output to ##,###,##.## . I dont want the commas and also I dont know what maximum decimal value is there in the table. It may be .001 or it maybe .0000001 . I just want them in simple expanded form.
karam --- Roger Baklund <[EMAIL PROTECTED]> wrote: > * 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] > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
