where convert(char(10),datetime类型的字段,120)='2003-01-15' --某一天的.where convert(char(10),datetime类型的字段,120)=convert(char(10),datediff(day,-1,getdate()),120) ---昨天的.
Select * from tablename where Convert(VarChar(10),datefield,20)=Convert(varChar(10),DateAdd(dd,-1,某日期),20)
当天: Select * from tablename where datediff(day,你的列,'2000-1-1')=0 今天: Select * from tablename where datediff(day,你的列,getdate())=0 昨天: Select * from tablename where datediff(day,你的列,getdate())=1 本月: Select * from tablename where datediff(month,你的列,getdate())=0 .....
对于表中的一个datetime类型(已精确到时分秒)的字段,如何查询某一日期的前一天的所有资料?用函数datediff select * from tablename where datediff(d,col,getdate())=1
select * from tablename where where convert(char(10),datetime类型的字段,120)=convert(char(10),dateadd(dd,-1,datetime类型的字段,120)
select * from tablename where where convert(char(10),datetime类型的字段,120)=convert(char(10),dateadd(dd,-1,datetime类型的字段),120)
Convert(VarChar(10),datefield,20)=Convert(varChar(10),DateAdd(dd,-1,某日期),20)
Select * from tablename where datediff(day,你的列,'2000-1-1')=0
今天:
Select * from tablename where datediff(day,你的列,getdate())=0
昨天:
Select * from tablename where datediff(day,你的列,getdate())=1
本月:
Select * from tablename where datediff(month,你的列,getdate())=0
.....
select * from tablename where datediff(d,col,getdate())=1