@Query("Select * From Mstudent where (strftime('%d%m',dob)) = :todayDate order by (strftime('%d%m',dob))")
List<Mstudent> getStudentByBirthDate(Date todayDate);
这就是我所做的,但这给了我一个错误,因为查询不正确。我们可以只按日期和月份过滤而忽略年份吗?
尝试此查询(如果您使用TypeConvertorDate
到Long
(:
@Query("Select * From Mstudent where strftime('%d%m',datetime(dob/1000, 'unixepoch'))= strftime('%d%m',datetime(:todayDate/1000, 'unixepoch')) order by strftime('%d%m',dob)")
List<Mstudent> getStudentByBirthDate(Date todayDate);
此查询可能您正在查找
"Select * From Mstudent where strftime('%d%m',datetime(dob/1000, 'unixepoch'))= strftime('%d%m',datetime(:todayDate/1000, 'unixepoch'))"