请教按时间段查询语句怎么写？

[jieke2002]

数据库中时间的字段名为load_date,格式如：2004－1－11，如何从数据库中查找出某一时间段内的记录？

[mikespook]

是什么类型？DATETIME？

[chinaworker]

select * from [table] where Abs(datediff(second,regtime,2004-4-5 23:00:00))=>0

[lwllp]

select * from [table] where load_date between '2004-1-11' and '2004-2-10'

如果用access的话，把 '2004-1-11' 改成 %2004-1-11%

[fenlin]

select * from [table] where load_date between #2004-1-11# and #2004-2-10#

[cjf1009]

select * from [table] where load_date between '2004-1-11' and '2004-2-10'

如果用access的话，把 '2004-1-11' 改成 #2004-1-11#

[zfwyyz]

那怎么定义时间呢
就dim d=2004-1-11 行吗，好象这样不行了

[pongid2353345]

dim d
d=#2004-1-11#

[pongid2353345]

哇，楼主的信誉分好低啊！！

[skyboy0720]

up