大家好!
我在数据表里有字段datetime类型的数据。有很多行纪录:
2008-12-01 00:12:00
2009-02-01 12:00:00
2009-03-01 00:45:00
2009-05-01 09:00:00
现在我想查询2009-01-01 00:00:00 到2009-04-01 00:00:00 之间的数据.我分别用了四个datetimepicker用来选择查询的开始日期和时间(datetimepicker1,datetimepicker2),结束的日期和时间(datetimepicker3,datetimepicker4),。
我用的数据库是sql2000, 不知道这个查询语句该怎么写,请大家帮忙!!
我在数据表里有字段datetime类型的数据。有很多行纪录:
2008-12-01 00:12:00
2009-02-01 12:00:00
2009-03-01 00:45:00
2009-05-01 09:00:00
现在我想查询2009-01-01 00:00:00 到2009-04-01 00:00:00 之间的数据.我分别用了四个datetimepicker用来选择查询的开始日期和时间(datetimepicker1,datetimepicker2),结束的日期和时间(datetimepicker3,datetimepicker4),。
我用的数据库是sql2000, 不知道这个查询语句该怎么写,请大家帮忙!!
select @bt='2009-01-01',@et='2009-04-01'
select * from tb where fdate >=@bt and fdate<@et
datetimepicker1+' '+datetimepicker2 AND datetimepicker3+' '+datetimepicker4
CONVERT(DATETIME,datetimepicker1+' '+datetimepicker2 )
AND
CONVERT(DATETIME,datetimepicker3+' '+datetimepicker4)
把你的日期,时间拼接起来。如:
select * from tb
where fdate>cast('2009-01-01 '+' 02:05:00' as datetime)
and fdate<cast('2009-04-01 '+' 02:05:00' as datetime)
*
from
tb
where
[time]
between
cast(datetimepicker1+' '+datetimepicker2 as datetime)
and
cast(datetimepicker3+' '+datetimepicker4 as datetime)
datetimepicker1+' '+datetimepicker2 AND datetimepicker3+' '+datetimepicker4