SQLite 时间范围

--昨天
-- select datetime('Now', 'start of day', '-1 day') dbegin,datetime('Now', 'start of day', '+0 day') dend
-- select * from T_B_Records where sTime>= datetime('Now', 'start of day', '-1 day') and sTime< datetime('Now', 'start of day', '+0 day') ORDER BY sTime

--今天
-- select datetime('Now', 'start of day', '+0 day') dbegin,datetime('Now', 'start of day', '+1 day') dend
-- select * from T_B_Records where sTime>= datetime('Now', 'start of day', '+0 day') and sTime< datetime('Now', 'start of day', '+1 day')

--上月
--select datetime('Now', 'start of month', '-1 month', '-0 day') dbegin,datetime('Now', 'start of month', '+0 month', '-1 day') dend
-- select * from T_B_Records where sTime>= datetime('Now', 'start of month', '-1 month', '-0 day') and sTime< datetime('Now', 'start of month', '+0 month', '-1 day')

--本月
-- select datetime('now','start of month','+0 second') dbegin,datetime('now','start of month','+1 month','-1 second') dend
-- select * from T_B_Records where sTime between datetime('now','start of month','+1 second') and datetime('now','start of month','+1 month','-1 second')

--本周
-- select datetime('now','start of day','-6 day','weekday 1') dbegin,datetime(datetime('now','start of day','weekday 0'),'start of day','+1 day') dend
-- select  * from T_B_Records where sTime>=datetime('now','start of day','-6 day','weekday 1') AND datetime(datetime('now','start of day','weekday 0'),'start of day','+1 day')