On 4/18/2014 8:49 AM, c...@isbd.net wrote:
Alternatively are there any other reasonably practical ways to format numeric output? Specifically I want to format floating point numbers into a fixed format like NNN.N.
Your application can provide custom functions callable from queries. Tcl example: $ tclsh % package require sqlite3 % sqlite3 db :memory: % db function printf format % db eval {select printf('%05.1f', 12.3)} 012.3 -- Andy Goth | <andrew.m.goth/at/gmail/dot/com> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users