用SQL，怎样用最简单的方法，判断一条记录是属于明天的！！

Question

select * from tablename where convert(varchar(10),dateadd(day,-1,datecol),120)=convert(varchar(10,getdate(),120)

Answer 1

select * from 表 where datediff(day,日期字段,getdate())=-1

Answer 2

select * from 表 where 日期字段>=getdate() and 日期字段<=dateadd(day,1,getdate())

Answer 3

select * from 表 where datediff(day,日期字段,getdate())=-1select * from 表 where datediff(day,getdate(),日期字段)=1

Answer 4

select * from table where to_char(datecol,'yyyymmdd')=to_char(sysdate,'yyyymmdd')+1

Answer 5

select * from 表 where datediff(day,日期字段,getdate())=-1

Answer 6

select * 
from tabName
where convert(varchar(10),dateField,120)=
convert(varchar(10),dateadd(dd,1,getdate()),120)

Answer 7

select * from tabName
where datediff(day,,getdate(),datField)=1

Answer 8

select * from 你的表 where datediff(day,日期字段,getdate())=-1