How to put dots in numbers in SQLite when displaying?

K

kommov2020-06-04 07:35:58

SQLite

kommov, 2020-06-04 07:35:58

How to make the number 100000000 appear as 100.000.000 (separators)?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

d-stream, 2020-06-04
@d-stream

I think select is not the right place to apply formatting. Maximum - cast to the desired format (for example, to decimal). And the display is format mask on the visualization. Here the specifics depend on the environment / jap