SQLServer如何查询在某一时间段的内容？

[RealBitMan]

我的一UploadDate是Char型，但填充的都是形如2004-4-4 12:23:34的时间数据，现在我要查询UploadDate在两个时间段2004-4-1和2004-6-4的内容,SQL语句怎么写？
前提：不要说在SQLServer中将UploadDate更改为DateTime类型，保留原Char类型！！！！！！！

[nnh]

用datadiff

[tfming]

Cast(UploadDate as datetime)就可以了！

[xjshuaishuai]

select * from table where inserttime>'2004-4-1' and inserttime<'2004-6-4'
select * from table where inserttime '2004-4-1' between '2004-6-4'

[yistudio]

>'2004-4-1' and <'2004-6-4'

[RealBitMan]

To tfming(明明):
Cast(UploadDate as datetime)写在哪？SQL语句中?
>'2004-4-1' and <'2004-6-4'这种方法不行的！！
2004-6-12日期的数据就查不出来了

[xjshuaishuai]

不需要转换的，直接能比较

[RealBitMan]

真的？怎么直接比较？

[xjshuaishuai]

select * from table where inserttime>'2004-4-1' and inserttime<'2004-6-4'
select * from table where inserttime '2004-4-1' between '2004-6-4'

[kisspy]

select * from table where data > '2004-4-1 00:00:00' and data < '2004-4-1 00:00:00'

[herman_chow]

select * from table where cast(UploadDate as datetime) between '2004-4-1' and '2004-6-4'