在SQLite选择日期基于月份大于另一月份:
SELECT id, start_date, end_date FROM recur WHERE strftime('%m%Y', start_date) <= '122012' AND strftime('%m%Y', end_date) >= '122012'
I have a row in the database with:
start_date = 2012-12-01
end_date = 2015-05-01
改变日期之后没有选出更大的月份。有办法么?