plus.sqlite无法取出Long的类型,项目有13位时间戳,类似1580914527123,这样的
然后select * from message就不行了出来的结果 就是类似以下的结果:
912321
9823233
-342232
数据是内置再数据库内的,为了进一步定位问题执行以下sql语句
SELECT id/10 as a, id/100 as b, id/1000 as c, datetime(id/1000, 'unixepoch', 'localtime') as dt from message
01:38:48.766 {"a":158000000,"b":15800000,"c":1580000,"dt":"1970-01-19 14:53:20"} at common/rj-lib/db.js:240
01:38:48.796 {"a":1580548650,"b":158054865,"c":15805486,"dt":"1970-07-03 06:24:46"} at common/rj-lib/db.js:240
01:38:48.826 {"a":-1374382677,"b":1580548650,"c":158054865,"dt":"1975-01-04 16:07:45"} at common/rj-lib/db.js:240
01:38:48.854 {"a":-858924872,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.884 {"a":-858924872,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.914 {"a":-858924871,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.944 {"a":-858924871,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.944 {"a":-858924870,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.969 {"a":-858924870,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.991 {"a":-822337252,"b":-1370723914,"c":1580914527,"dt":"2020-02-05 22:55:27"} at common/rj-lib/db.js:240
由上可见当sqlite的integeer类型,大于10位就无法取出,如果取出长度是10位就没问题,11,12,13都不行,
请小编帮解决下问题
以上只在安卓上测试
2 个回复
freewolf
同问帮顶
国环地标
一样的问题 希望官方给出解释