当你的才华不能撑起你的野心时,就是你该选择学习的时候了!

C# EF Linq SqlFunctions.DatePart

                if (!string.IsNullOrEmpty(searchInfo.AuthorisedDate))
                    list_A = list_A.Where(q => q.AUTHORISED_DATE.HasValue && SqlFunctions.DatePart("yyyy", q.AUTHORISED_DATE) == SqlFunctions.DatePart("yyyy", searchInfo.AuthorisedDate) && SqlFunctions.DatePart("mm", q.AUTHORISED_DATE) == SqlFunctions.DatePart("mm", searchInfo.AuthorisedDate) && SqlFunctions.DatePart("dd", q.AUTHORISED_DATE) == SqlFunctions.DatePart("dd", searchInfo.AuthorisedDate));

 

posted @ 2023-09-07 10:58  hofmann  阅读(61)  评论(0)    收藏  举报