Show number with thousands separator

(1) By anonymous on 2020-04-21 19:20:46

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 [link]

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.