sql里日期处理问题

[iif]

我想从user 表中取出dateline等于2001-12-14日这天的用户,
SELECT *
FROM user
WHERE dateline = '2001-12-14'

但明明有数据的，怎么就取不出来呢？

原来发觉数据库表中的数据是长日期型的（如:2001-12-14 10:10:10）

请问我怎么样才能取出数据呢谢谢
~~~~~~~~~~~~~~

[linefire]

SELECT *
FROM user
WHERE dateline between '2001-12-14 00:00:00' and '2001-12-14 23:59:59'

[iif]

老兄
我的日期是外部输入的哦
2001-12-14这个东东是外部输入的哦

[lazywolf]

select * from user where datediff(dd,"2001-12-14",dateline)=0

[lazywolf]

select * from user where datediff(dd,'2001-12-14',dateline)=0

[ePing]

select * from user where convert(smalldate, dateline) = convert(smalldate,
convert(datetime, '2001-12-14'))

[luojx]

外部输入是文本形的
应该先转化成日期形，就像eping 说的
然后再用lazywolf说的那个函数比较
就行了