sql中如何获取某个时间段内的数据

[xueyuehen]

时间的字段是varchar类型 的！！
如何获取一段时间段内的数据呢。。。。。。

[dawugui]

select * from tb where cast(字段 as datetime) between 时间1 and 时间2

[Limpire]

那要看你的时间格式是什么样的了

[dawugui]

--例如:
select * from tb where cast(字段 as datetime) between '2008-01-01' and '2008-05-01'

[fuanwei]

select * from 表 where cast(列名 as datetime)>='2008-02-05' and cast(列名 as datetime)<='2008-02-05'

[rockyvan]

Select *
From TB
Where Time Between '08:00:00' And '20:00:00'

[kk19840210]

[Quote=引用 3 楼 dawugui 的回复:]
SQL code--例如:
select * from tb where cast(字段 as datetime) between '2008-01-01' and '2008-05-01'
[/Quote]

[xueyuehen]

时间格式是 2008.1.1

[flairsky]

啊哈，你这形式可以转换过来