C# EF Linq SqlFunctions.DatePart

发布时间 2023-09-07 11:03:51作者: hofmann
                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));