Hi all,
Short question:
This: select datetime(julianday('2008-06-12',
'utc'), 'localtime')
should give this: 2008-06-12 00:00:00
but instead gives this: 2008-06-11 24:00:00
Is this a known bug?
More detail:
I am storing dates in julianday (real) format. When I store a date I
store it as UTC offset and convert it to localtime when displaying it.
So, using an example date, my formula (obviously simplified here)
boils down to:
select datetime(julianday('2008-06-12', 'utc'), 'localtime')
or when I just want the date component:
select date(julianday('2008-06-12', 'utc'), 'localtime')
But I get unexpected answers:
2008-06-11 24:00:00 (I expected 2008-06-12 00:00:00)
and:
2008-06-11 (I expected 2008-06-12)
This seems to me to be a bug, especially because it doesn't make sense
for the datetime function to return a date plus 24 hours.
It seems to be some rounding error in the date and datetime functions.
I can manually "fix" it by:
select datetime(julianday('2008-06-12', 'utc'), '0.1 seconds', ,
'localtime')
or when I just want the date component:
select date(julianday('2008-06-12', 'utc'), '0.1 seconds', 'localtime')
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
