On 4/18/2014 8:49 AM, [email protected] 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
