获取同一天的记录
var getTodayList = db.Queryable<Student>().Where(it => SqlFunc.DateIsSame(it.CreateTime, DateTime.Now)).ToList();
SELECT ID,PXLB,CONVERT(PXTuJing,CHAR) as PXTuJing from Qysc_trainingduty where DELETEMARK=0
select DATE_FORMAT(now(),'%Y-%m-%d %H:%i:%s') from dual;