sql的日期查询

1、 dw,weekday -----------表示某个星期的第几天 ltrim(rtrim(title))----------清除title的左右空格 --查询同一天的 select * from loginlog where datediff(day,logintime,'2007-12-28')=0 --查询同一星期的 第一种：select * from loginlog where datepart(week,logintime)=datepart(week,'2007-12-11'); 第二种：select * from loginlog where datediff(week,logintime,'2008-01-16')=0 --查询同一月的 select * from loginlog where datediff(month,logintime,'2007-12-28')=0 --查询一个时间段的 select * from loginlog where datepart(dy,logintime)>datepart(dy,'2007-01-01') and datepart(dy,logintime) datepart(dy,'2008-01-10') and datepart(dy,logintime) =12 then substring(notetitle,0,12)+'...' else notetitle end from mynote where createuser='admin' 相关的查询示例： select * from stumarks --原始成绩 pring 'ABCDE五级显示成绩如下：' select stuno,成绩=case when writtenExam<60 thten 'E' when writtenExam between 60 and 69 then 'D' when writtenExam between 70 and 79 then 'C' when writtenExam between 80 and 89 then 'B' else 'A' from stumarks --操作临时表 select len(sunday1), * from ( select sunday1 from schedule ) temp