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
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
(
voy_no varchar(20),
eta char(8)
)
GOINSERT 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)<20051108DROP TABLE voyage
voy_no
FROM
voyage
WHERE eta BETWEEN '开始时间' AND '结束时间'
SELECT voy_no FROM voyage WHERE eta>'2004-12-02' and eta<'2005-01-02'
SELECT voy_no FROM voyage WHERE eta between 20041202 and 20050102
eta 非数值型
SELECT voy_no FROM voyage WHERE eta between '20041202' and '20050102'