String str_sql = "select * from health_advice where adviceTime between datetime('"
+ history
+ "','localtime') and datetime('"
+ history
+ "','start of day','localtime','+1 month')";
String str_sql = "select * from health_advice where adviceTime between datetime("
+ history
+ ",'localtime') and datetime("
+ history
+ ",'start of day','localtime','+1 month')";
------解决方案--------------------
难道你的sql语句拼的不对?
String str_sql = "select * from health_advice where adviceTime between datetime('"
+ history
+ "','localtime') and datetime('"
+ history
+ "','start of day','localtime','+1 month')";