ASP ACCESS 日期操作语句小结 By Stabx

代码如下:13.5.1 列出某一天, 上一星期的数据 SELECT distinct dateandtime FROM ctdate_by_query_date WHERE dateandtime between ((#2006-5-15#+(Weekday(2006-5-15)-7))-6) and (#2006-5-15#-7)+Weekday(2006-5-15) sql=”SELECT distinct dateandtime FROM ctarticle WHERE dateandtime between ((#”&date&”#+(Weekday(“&date&”)”&norp&”