如何获得今天的日期？？？？？

[maverickliu]

假设表table1中有个日期型字段time1，现在想select出time1为今天的数据，该怎么写sql语句啊，谢谢！

[pengdali]

getdate()

[pengdali]

select * from table1 where datediff(day,日期,getdate())=0

[pengdali]

select dateadd(month,-24,'2002-12-14')
---------------------^^^减
select dateadd(day,-24,'2002-12-14')
----------------^^^天或year年

[pengdali]

select datediff(day,'2001-1-1','2002-1-1') 天
select datediff(month'2001-1-1','2002-1-1') 月
select datediff(year,'2001-1-1','2002-1-1') 年

[pengdali]

select datediff(day,'2001-1-1','2002-1-1') 天
select datediff(month'2001-1-1','2002-1-1') 月
select datediff(year,'2001-1-1','2002-1-1') 年