求问一个关于在某一段日期内查询的语句！！

[zandh]

我现在有如下表：
table: voyage
fields: voy_no eta
SSS 20050102
XXX 20041202
TTT 20051108

我想查询在给定的两个时间参数内的航次，应该如何写？
谢谢各位大侠赐教！！！！！

[zandh]

谢谢，我还以为要对日进行判断比较呢

[cen123]

eta必须INT型
SELECT voy_no FROM voyage WHERE eta>20041202 and eta<20050102
eta如果是char类型的
SELECT voy_no FROM voyage WHERE cast(eta as int)>20041202 and cast(eta as int)<20050102

[cen123]

CREATE TABLE voyage
(
voy_no varchar(20),
eta char(8)
)
GO

INSERT INTO voyage SELECT 'SSS','20050102'
UNION SELECT 'xxx','20041202'
UNION SELECT 'ttt','20051108'

SELECT voy_no FROM voyage WHERE cast(eta as int)>20041202 and cast(eta as int)<20051108

DROP TABLE voyage

[zlp321002]

SELECT
voy_no
FROM
voyage
WHERE eta BETWEEN '开始时间' AND '结束时间'

[-狙击手-]

SELECT voy_no FROM voyage WHERE cast(eta as int)>20041202 and cast(eta as int)<20051108

[gujianmin]

如果eda为date/datetime类型
SELECT voy_no FROM voyage WHERE eta>'2004-12-02' and eta<'2005-01-02'

[小辉]

eta 数值型
SELECT voy_no FROM voyage WHERE eta between 20041202 and 20050102
eta 非数值型
SELECT voy_no FROM voyage WHERE eta between '20041202' and '20050102'