[sqlite] printf with thousands separator

2015-10-19 Thread Clemens Ladisch
Bruce Hohl wrote: > Is printf with thousands separator working for anyone? No. SQLite's printf is designed for database-internal processing (e.g., sorting), and does not support locales. Formatting values for display is the responsibility of the application. (The sqlite3 command-line shell has

[sqlite] printf with thousands separator

2015-10-14 Thread Bruce Hohl
I create quite a few ad hoc queries from data tables with large numbers and the default floating output is a pain to read. I can get the output format I desire with something elaborate like the following but this is too much SQL for ad hoc queries. select substr( replace( substr('