sqllite 拼接字符串

sqllite 拼接字符串用"||"，如拼接日期

select * where IsDel=0 and datetime(strftime('%Y','now')||'-'||strftime('%m-%d',MemberBirthday))>=datetime('2016-11-02') and datetime(strftime('%Y','now')||'-'||strftime('%m-%d',MemberBirthday))< datetime('2016-11-09')