获取同一天的记录

获取同一天的记录

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;