SQLite query: Format thousands seperator

[Amundsf]

Hi

I try to format a float from SQL-query to have thousands seperator. It must be dot (.) or space as sperator, not comma.

If I can choose the result would be like 5.432,00 or 5 432,00

5.5432 or 5 432 will also be better than today.

I have found format("%,d", amount) but that result in 5,432 wich don't work.

I did see a few other suggestions when googling, but didn't get them to work.

Does anyone have a solution for this?

Thank you in advance

 - Amund

[Er Mo]

Hallo

Ich glaube das das mit den Länder einstellungen von Betribssystem zusammen hängt . Da sind Datum , Zeit und so angegeben . Weiters gibt es bei den Einstellunger von Feldtyp mit Zahlen , Währung die möglichkeit den Tausenter Punktes .

Hello
I think this has something to do with the country settings of the operating system. Date, time, and so on are specified there. Furthermore, in the field type settings with numbers and currency, there's the option to use the thousandth point.

Ernst

[Amundsf]

Hi

Yes, if it was a field in Memento it would have been the regional settings.

But this is a SQL-query, I don't think that regional settings apply for that.

 - Amund

[Er Mo]

Hallo

Die weise wie die Daten dargestellt werden muss nicht mit den Daten gespeichert werden . Der Punkt bei Tausent gehört hir dazu .

Hello
The way the data is displayed doesn't have to be stored with the data. The point at thousand is part of this.

Ernst

[Amundsf]

Hi

I have a feeling we maybe talk about different things?
I'm using search (magnifying glass) -> SQL-icon upper right corner
Here I have written a pretty complex SQL Query -> Save as SQL-presets

In Entry's list I get it by selecting that Presets

I don't think that Memento have a "layer" on top of this to select thousands seperator?
When googling "SQLite thousands seperator" it's a familiar case that it's a bit tricky to get it to by anything else than , I think.

Amund