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.
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 GUI tools compared at:
> http://www.tandb.com.au/sqlite/compare/?ml
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
