On Fri, Feb 19, 2016 at 12:36 AM, k <kmccord0001 at gmail.com> wrote:
> On 18/02/2016 21:55, Stephan Beal wrote: > >> >>> http://fossil.wanderinghorse.net/download/cal.sql >>> >>> >> Excellent CTE query, thanks, but one question: the query uses > group_concat() and the documentation says 'The order of the concatenated > elements is arbitrary.' > Great question, and Keith answered it for both of us. i've been tinkering (and just uploaded)... It can now optionally mark the current date (but this feature slowed it down from 'instant' to 'just under a second or so', possibly due to SQL inefficiencies on my part). It also allows one to specify utc or localtime. (Yes, it actually made a difference in the results for me at the time i added that feature, which was why it was added.) [stephan at host:~/tmp]$ sqlite3 < cal.sql +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ Jan 2016 Mo Tu We Th Fr Sa Su 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ Feb 2016 Mo Tu We Th Fr Sa Su 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 (19) 20 21 22 23 24 25 26 27 28 29 +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ Mar 2016 Mo Tu We Th Fr Sa Su 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
