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

1 posts

grade1000 posted 3 years ago in Feature discussion

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.