SQLite Forum

Show number with thousands separator
Login

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.