OK, so having worked out how to extract maximum and minimum values for each year from my database (thanks Mark), how do I format them?
Here's what I get at the moment:-
Year MaxTemp MinTemp MaxOutside MinOutside 2010 14.0625 -0.9375 7 -7.6875 2011 25 -2.1875 41.9375 -8.6875 2012 85 -6.25 37.8125 -14.0625 2014 22.125 5.875 32.875 0.5625
It's actually presented as a table in DokuWiki but that doesn't really affect the issue. How do I get the temperatures shown in sensible, consistent format like NNN.N?
According to http://www.sqlite.org/lang_corefunc.html sqlite has a printf() function but when I tried it I got an error saying "No such function: printf" and I can't find anything useful about it by Googling for the error or anything related.
So any ideas, apart from horrible substr() manipulations?
I *could* go into the Dokuwiki plugin I'm using to get the output from the database into tabular format, I've modified it a lot already, but it would be rather messy to do. So I'd like something I can do outside if possible.