select o.* from user o where 1=1 and userId = 100041 and createTime between '2016-05-04' and '2016-05-06' order by o.createTime desc
始终缺少当天比如六号那天的记录,该怎么办?
估計預設的是 2016-05-06 00:00:00 了你用 createTime between '2016-05-04 00:00:00' and '2016-05-06 23:59:00:00' and '2016-05-06 23:59:59'
從使用者 o 中選擇 o.*,其中 1=1 且 userId = 100041 且 createTime 介於 '2016-05-04' 和 '2016-05-07' 之間,按 o.createTime desc 排序
估計預設的是 2016-05-06 00:00:00 了
你用
createTime between '2016-05-04 00:00:00' and '2016-05-06 23:59:00:00' and '2016-05-06 23:59:59'
從使用者 o 中選擇 o.*,其中 1=1 且 userId = 100041 且 createTime 介於 '2016-05-04' 和 '2016-05-07' 之間,按 o.createTime desc 排序