On Tue, Apr 4, 2017 at 3:47 PM, Hans M. van der Meer <[email protected]> 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 <[email protected]>: > > 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
