Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

SQLite output default in scientific notation

grade1000's profile image grade1000 posted 1 month ago in Feature discussion Permalink

The floating point is being presented by definition in SQLite with scientific notation. This could be easily resolved by placing, examples:

SELECT printf("%f", abs(1.0/1000000));

SELECT "_rowid_","id",printf('%f', "bid") AS "bid" FROM "main"."q1";

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.