查詢本月
where a.create_time between datetime('now','start of month','+1 second') and
datetime('now','start of month','+1 month','-1 second')
查詢多少天之内
where julianday(datetime('now','localtime'))-julianday(a.create_time) <300
這明白的就是和sqlserver 幹啊 連個datediff都沒有 你吃屎吧!