上一星期(七天之内)：select * from art where [now] between dateadd("ww",-1,now()) and now()上一星期(上周一至周日)：select * from art where [now] betwee
上一星期(七天之内)：select * from art where [now] between dateadd("ww",-1,now()) and now()上一星期(上周一至周日)：select * from art where [now] between dateadd("d",-Weekday(Now())-5,now()) and dateadd("d",-Weekday(Now())+1,now())上一月(yuè)(上月(yuè)的(de)今天至今天)：select * from art where [now] between dateadd("m",-1,now()) and now()上一月(yuè)(1号至最後一天)：select * from art where [now] between dateserial(year(now),month(now())-1,1) and dateserial(year(now),month(now()),1-1)在ACCESS數據庫中，日期時(shí)間的(de)比較操作符主要有>= 、<=、=三個(gè)！但不能直接把比較時(shí)間用(yòng)這(zhè)些操作符相連！爲了(le)區(qū)分(fēn)時(shí)間類型和(hé)其它類型，ACCESS中在時(shí)間比較時(shí)在時(shí)間兩端要加上#！例如，要查詢2007-1-1日到2007-7-2日之間的(de)信息，SQL語句可(kě)以寫成：Select * form table where datefield >=#2007-1-1# and datefield <=#2007-7-2#在asp程序中對(duì)應得(de)SQL串爲：exsql="select * form table where datefield >= # 2007-1-1 # and datefield<=# 2007-7-2 # "如果把查詢的(de)時(shí)間換成一個(gè)其他(tā)頁面傳來(lái)的(de)變量的(de)話(huà)，SQL串對(duì)應修改爲：exsql="select * from table where datefield>=#" &Begindate& "# and datefield<= #" &Enddate& "#" ，其中變量Begindate和(hé)Enddate分(fēn)别是查詢的(de)起始時(shí)間和(hé)結束時(shí)間。列出某一天, 上一星期的(de)數據：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&"7))-6) and (#"&date&"#"&norp&"7)+Weekday("&date&")"查詢一天, 所隸屬星期所有天數的(de)數據：SELECT * FROM ctdate_by_query_date WHERE dateandtime between ((#2006-5-15#+Weekday(2006-5-15))-6) and #2006-5-15#+Weekday(2006-5-15)查詢一個(gè)時(shí)間段 SELECT * FROM ctdate_by_query_date WHERE dateandtime between #2006-5-1# and #2006-5-30#列出不同年份的(de)年份, 并且不要相同：select distinct year(dateandtime) from ctarticle結果如： Expr1000 2000 2003 2004 2005 2006列出某一天, 上一年的(de)第一條記錄：SELECT top 1 dateandtime FROM ctarticle where year(dateandtime)=(2006)-1sql="SELECT top 1 dateandtime FROM ctarticle where year(dateandtime)=(year(#"&date&"#))"&norp列出某一年的(de)數據：sql="select * from ctdate_by_query_date where year(dateandtime)="&year(rqqdt_)&" order by dateandtime desc" 查找上一月(yuè)中的(de)第一條記錄：SELECT top 1 dateandtime FROM ctarticle where year(dateandtime)=year(#2006-5-28#) and month(dateandtime)=month(#2006-5-28#)-1列出某一月(yuè)的(de)數據：sql="select * from ctdate_by_query_date where year(dateandtime)="&year(rqqdt_)&" and month(dateandtime)="&month(rqqdt_)&" order by dateandtime desc"列出某一日的(de)數據：sql="select * from ctdate_by_query_date where dateandtime=#"&rqqdt_&"# order by a.articleid desc"列出當天的(de)數據：sql="select * from ctdate_by_query_date where dateandtime=date() order by a.articleid desc"
