有一个字段是 varchar型,字段里面存的是2003-6-9 8:00:00这样的数据.

[renren6250]

有一个字段是 varchar型,字段里面存的是2003-6-9 8:00:00
或者是 2003-8-3这样的数据.
如下：表里这样的数据:
2003-6-9 8:00:00
2003-6-2
2003-6-12 10:02:13
2003-6-9 9:23:04
2003-6-11
我通过什么样的查询能得出如下数据
2003-6-12 10:02:13
2003-6-9 9:23:04
2003-6-11
也就是两个时间端的内容,谢谢大家

[CrazyFor]

不明白怎么分时间端!!`

[pengdali]

select * from 表 where cast(字段 as datetime) between '开始时间' and '结束时间'

[愉快的登山者]

select * from yourtable where col between '2003-6-9 9:23:04' and '2003-6-12 10:02:13'

愉快的登山者

⊙
◢◣◢◣◢◣

[hugeforest]

select * from table where cast(字段 as datetime) >= '2003-6-9 9:23:04'

[amtyuranus]

select * from table where convert(col,datetime,130) >'shijian' and convert(col,datetime,130) <'shijian'

[happydreamer]

where cast( 字段 as datetime) between '2003-6-9 9:23:04' and '2003-6-12 10:02:13'

[happydreamer]

where cast( 字段 as datetime) between '2003-6-9 9:23:04' and '2003-6-12 10:02:13'

[happydreamer]

where cast( 字段 as datetime) between '2003-6-9 9:23:04' and '2003-6-12 10:02:13'

[hjb111]

select * from yourtable where cast( 字段 as datetime) between '2003-6-9 9:23:04' and '2003-6-12 10:02:13'

[zjcxc]

select * from 表 where 字段 in('2003-6-12 10:02:13','2003-6-9 9:23:04','2003-6-11')

[zjcxc]

两个时间段之间的记录,用convert进行数据类型转换就行了.

select * from 表 where cast(字段 as datetime) between '2003-06-09' and '2003-6-12 10:02:13'