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));

浙公网安备 33010602011771号