求助

[karon311]

请问我想从表a中查询2003-10-1到2003-10-7这个时间段中的表中的所有记录
请问sql语句怎么写

[dickeybird888]

(1)如果是ACCESS数据库，则为：
select * from table1 WHERE mydate>=#2003-10-01# and mydate<=#2003-10-7#
(2)如果是ORACLE数据库，则为：
select * from table1 WHERE mydate>=cast('2003-10-01' as date) and mydate<=cast('2003-10-7' as date)

[dickeybird888]

sqlserver
select * from table1 where mydate>='10/1/2003' and mydate<='10/7/2003'

[hmzgz81]

呵呵 ！ 又是你！ 楼上的 好快啊！