sql语句中日期时间类型怎么比较？

[db2notes]

数据库中有这样的2009-8-12 13:17:50 数据记录

现在select * from table1 where date>'2009-8-12 13:17:50'
和select * from table where date>#2009-8-12 13:17:50#都通不过

盼高人指点一二

[feixianxxx]

select * from table1 
where datediff(mm,'2009-8-12 13:17:50', date)>0

[feixianxxx]

select * from table1 
where datediff(ms,'2009-8-12 13:17:50', date)>0

[--小F--]

select 
   * 
from 
   table1 
where 
   datediff(mm,'2009-8-12 13:17:50', date)>0

DATEDIFF
返回跨两个指定日期的日期和时间边界数。 

语法
DATEDIFF ( datepart , startdate , enddate 

[db2notes]

除了用datediff还有其他方法吗？

[--小F--]

--TRY
select * from table1 where cast(date as datetime)>'2009-8-12 13:17:50'

[db2notes]

呵呵，谢谢！

[SQL77]

select * from table1 where CONVERT(DATETIME,date)>'2009-8-12 13:17:50' 

[上善若水_厚德载物]

datediff or dateadd 搞定

[让你望见影子的墙]

select * from table1 where date>'2009-8-12 13:17:50'
如果date是datetime的话，应该可以直接比较的。

[ys_pqy]

专家回答的速度真是快啊

[guguda2008]

DATEDIFF
CAST
CONVERT
还可以用YEAR(),MONTH(),DAY(),或者DATEPART()分别取各个部分进行判断

[w11x22b33]

oracle:
select * from table1 where date>to_date('2009-8-12 13:17:50','yyyy-mm-dd')
db2:
select * from table1 where date>date('2009-8-12 13:17:50','yyyy-mm-dd')