日期问题——随笔

一、判断两个日期是否在同一周

1、在c#中

//判断两个日期是否在同一周
        private bool IsInSameWeek(DateTime dtmS, DateTime dtmE)
        {
            TimeSpan ts = dtmE - dtmS;
            double dbl = ts.TotalDays;
            int intDow = Convert.ToInt32(dtmE.DayOfWeek);
            if (intDow == 0) intDow = 7;
            if (dbl >= 7 || dbl >= intDow) return false;
            else return true;
        }

2、C#使用sql语句

 articles = from s in db.Article.Where(x => SqlFunctions.DateDiff("week", x.PubTime, stime) == 0)
                               select s;