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
