Show number with thousands separator
(1) By anonymous on 2020-04-21 19:20:46 [link] [source]
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 [source]
Upgrade to SQLITE version 3.18.0 or later.
(3) By anonymous on 2020-04-21 19:40:03 in reply to 2 [link] [source]
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.