On 6/12/08, Shane Harrelson <[EMAIL PROTECTED]> wrote:
> I was able to reproduce this by setting by TZ to GMT +10:00. It's a
> floating point rounding issue in the julian date functions. We're
> investigating how to best correct it, but I don't have a "fix" for you now.
I can reproduce this bug on Mac OS X 10.5.3 with SQLite 3.5.9 without
having to tinker with TZ.
>
>
> On 6/12/08, BareFeet <[EMAIL PROTECTED]> wrote:
> >
> > Hi Shane,
> >
> > >> This: select datetime(julianday('2008-06-12','utc'),
> > >> 'localtime');
> > >>
> > >> should give this: 2008-06-12 00:00:00
> > >>
> > >> but instead gives: 2008-06-11 24:00:00
> >
> > > Can you provide some details of your test setup? What version of
> > > SQLite?
> > > What platform (compiler, O/S, processor, 32bit vs 64bit, etc.)?
> >
> > I'm using Mac OS X 10.5.3 on an iMac Intel dual 2.4GHz. I'm in
> > Australia, near Sydney (GMT +10:00 I think).
> >
> > I get the same result above when using the command line tool of the
> > built in SQLite version 3.4.0 or the latest binary version 3.5.9.
> >
> > FYI, this: select julianday('2008-06-12','utc');
> > gives: 2454629.08333333
> >
> > and this: select datetime(2454629.08333333, 'localtime');
> > gives: 2008-06-11 24:00:00
> >
> > Thanks,
> > Tom
> > BareFeet
> >
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
