查找大于某个日期的SQL语句如何写，谢谢

[htys3]

字段名：firstyear
类型：datetime
用SQL实现大于2003-09-01的语句如何写？谢谢

[gmlxf]

select * from yourtable where firstyear>'2003-09-01'
select * from yourtable where datediff(day,firstyear,'2003-09-01')>0

[aierong]

select * from tablename
where datediff(day,firstyear
,'2003-09-01')>0

[welyngj]

select * from tbl where firstyear>'2003-09-01'

[zjcxc]

select * from 表名 where firstyear>'2003-09-01'

或:
select * from 表名 where datediff(day,firstyear,'2003-09-01')>0

或:
select * from 表名 where convert(varchar(10),firstyear,102)>'2003-09-01'

[zjcxc]

是120,不是102,最后一个改为:
或:
select * from 表名 where convert(varchar(10),firstyear,120)>'2003-09-01'

[qong]

select* from tb1 where firstyear>ctod('2003-09-01')

[dgljf]

select * from 表名 where datediff(day,'2003-09-01', firstyear)>0

是小的日期在前面吧,不是嗎?

[lanslotliu]

select * from tbl where firstyear>'2003-09-01'
或
select * from tbl where firstyear between '2003-09-1' and sysmax