c# 处理时间函数

从数据库获取时间，并减一天：

var realTime = (from mmr in db.BSM_WaterMeter_Record
                            orderby mmr.Sdate descending
                           select mmr.Sdate).FirstOrDefault();
            var dt = (DateTime)realTime;
            var yesterday = dt.AddDays(-1);