如何比较Date 类 返回
SqlSugar
老数据
2
1641
悬赏:5 飞吻
类:
public class Claim {
public int Id {get; set;}
public DateTime? Created {get; set;}
}在代码中如写比较 savedClaimsExpiryDate<=Created , 而且把time部分改成 "00:00:00" 后再作比较, EntityFramework 中是用DbFunctions.TruncateTime,但不知道在SQLSugar怎么用
代码:
var savedClaimsExpiryDate = DateTime.UtcNow.AddDays(-14); this._dbContext.Db.Queryable<Claim>().Where(x=>SqlFunc.HasValue(x.Created) && ??)
热忱回答(2)
-
fate stay night VIP0
2019/5/2Sqlfunc.totine
0 回复 -
fate stay night VIP0
2019/5/2Time
0 回复