Hi Stephan, On 18 February 2016 at 13:55, Stephan Beal <sgbeal at googlemail.com> wrote: > On Thu, Feb 18, 2016 at 10:42 PM, Stephan Beal <sgbeal at googlemail.com> > wrote: > >> Here we go: >> >> http://fossil.wanderinghorse.net/download/cal.sql >> > > sorry, one more: it was just updated with minor doc improvements and better > syntax conformance (i had used a lot of double-quotes simply out of recent > scripting habit). > >
I periodically run your cal sql query to get a quick calendar view of the months and because it's really neat what you did with sql. Running sqlite3 trunk on a raspberry pi, I get this: +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ May 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 +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ (8) is on Saturday, that's correct for 2016. Running sqlite3 trunk on x86 64bit ubuntu system, I get this: +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ May 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 +~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ (7) is on Friday and in fact, all the days are shifted once. Both of those are a bit difficult to follow here so this link has both: http://kopy.io/NLViy What would cause the same exact cal.sql file obtained from your link be displayed differently on different architectures but the same sqlite3 version? Both sqlite3 versions were installed from trunk and configured with plain ./configure > -- > ----- 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 -- ------- inum: 883510009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si