因为
sqlite是没有floor函数的
所以用
cast(x as int) - (x < cast(x as int))
原理
cast(1.1 as int) = 1
cast(-1.1 as int) = -1(我们想要的结果为2)
如果x为非负
cast(x as int)是可以的
但是有负的话就加上后面
(x < cast(x as int))
因为
sqlite是没有floor函数的
所以用
cast(x as int) - (x < cast(x as int))
原理
cast(1.1 as int) = 1
cast(-1.1 as int) = -1(我们想要的结果为2)
如果x为非负
cast(x as int)是可以的
但是有负的话就加上后面
(x < cast(x as int))