以下分别为获取本天、本周、本月数据需要的where条件,其中publishDate为数据库里面存储的日期字段
此代码是在查询oracle数据库的.net 代码
DateTime today = DateTime.Now;
whereDay = string.Format("to_char(publishDate,'yyyy-mm-dd') ='{0}' ",
today.ToString("yyyy-MM-dd")
);
whereWeek = string.Format("to_char(publishDate,'yyyy-mm-dd') >='{0}' and to_char(publishDate,'yyyy-mm-dd')<='{1}' ",
today.AddDays(0 - (int)today.DayOfWeek).ToString("yyyy-MM-dd"),
today.ToString("yyyy-MM-dd")
);
whereMonth = string.Format("to_char(publishDate,'yyyy-mm-dd') >='{0}' and to_char(publishDate,'yyyy-mm-dd')<='{1}' ",
today.ToString("yyyy-MM-00"),
today.ToString("yyyy-MM-dd")
);