Hello I searched on the web site and "The definitive guide to SQLite", but didn't find if it's possible to format the output from the SUM() function:
SELECT SUM(invoice_amount) AS Amount FROM invoice"; => With invoice_amount defined as TEXT, I'd like this number to be formatted as "100.000,00', ie. using the dot as the thousands' separator, and the comma as the decimal separator. If required, I can turn this from TEXT to REAL, but I'd rather keep this column as TEXT. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users