嗨,我对这个方法的结果有问题:
@Query(value = "select * from Mail where sent_Flag = 0 and scheduled < '?1'", nativeQuery = true)
public List<Mail> getToSend(Long timestamp);
如果我设置值0或当前时间戳结果相同(返回所有记录,如计划的1=1(,如果我尝试直接通过SQL运行它,一切都正常,哪里有问题?
我正在使用SQLite和springboot
不确定原因,但适用于">
select * from Mail where sent_Flag = 0 and scheduled between 0 and ?