select top 1 * from voteSubjects where datediff('d',endTime,date())<1 and datediff('d',beginTime,date())>=1 order by id desc
就是这个函数datediff
select top 1 * from voteSubjects where datediff('d',endTime,date())<1 and datediff('d',beginTime,date())>=1 order by id desc