On Mon, May 9, 2016 at 7:00 PM, jungle Boogie <jungleboogie0 at gmail.com> wrote:
> On 8 May 2016 at 23:13, Stephan Beal <sgbeal at googlemail.com> wrote: > > On Mon, May 9, 2016 at 5:40 AM, Stephan Beal <sgbeal at googlemail.com> > wrote: > > > >> That suggests that the script is not consistently telling sqlite which > TZ > >> to use in all calculations. i will take a look at it as time > >> > > > > just fyi: i can now reproduce the problem on my x64, where my days are > > shifted 1 to the left. Not sure what's causing it, but probably won't be > > able to look at it until next weekend :/. i apparently broke it at some > > point without noticing. > > > Not a problem. Thanks for checking into this and I'm happy to know > this is not sqlite problem! Something to try out, if you have a machine handy: change all of the strftime date creation references and add " 23:59". i.e. move them to the end of the day. That might offset any calculations being done with the default(?) time of midnight (the _start_ of the day). -- ----- 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