Show number with thousands separator
(1) By anonymous on 2020-04-21 19:20:46 [link]
column is INTEGER SQLite version 3.16.2 2017-01-06 16:32:41 SELECT Country, Population, printf("%,d",Population) as PopF Error: near "%": syntax error How can I show the numbers with comma-thousand-separators? Thanks
(2) By Richard Hipp (drh) on 2020-04-21 19:31:12 in reply to 1 [link]
Upgrade to [SQLITE version 3.18.0][1] or later. [1]: https://www.sqlite.org/releaselog/3_18_0.html
(3) By anonymous on 2020-04-21 19:40:03 in reply to 2
Thanks Richard! I'll give it a go soon. Also want to commend you guys on the robustness and stability and excellent documentation of SQLite, and for making it public domain. Thanks for your hard work.