On Tue, Apr 4, 2017 at 3:47 PM, Hans M. van der Meer <drsme...@gmail.com> wrote:
> Simon, thanks. > Now at last, I know how to continue. > But SQLite itself ships with a portable version of printf too. So you can convert your integer or real typed columns into text typed ones for display, directly in SQL, as an alternative to doing it in PHP. --DD https://sqlite.org/lang_corefunc.html#printf > 2017-04-04 15:03 GMT+02:00 Simon Slavin <slav...@bigfraud.org>: > > SQLite is a database system. It is used for storing and retrieving > > information, not formatting it for people. When presenting your numbers > to > > people, do your formatting in PHP using sprintf() or vprintf(). > > > > http://php.net/manual/en/function.sprintf.php > > http://php.net/manual/en/function.vprintf.php > > > > See example #5 for sprintf() for "padding" which a word relating > to alignment. > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
