求助！SQL查询语句。

[hsx49949046]

我想查询数据库里时间为2008-8-8至2008-12-1之间的所有数据。应该怎么写？

[lizhengnan]

select * from table
where datecol>='2008-8-8'
and datecol>='2008-12-1'

[lizhengnan]

select * from table
where datecol>='2008-8-8'
and datecol<='2008-12-1'

最好加上时间.

select * from table
where datecol>='2008-8-8 0:00:00'
and datecol<='2008-12-1 23:59:59'

[tanghuiming]

select * from table where time>'2008-08-08' and time<'2008-12-01'

[bw555]

select * from table where time>='2008-08-08' and time <'2008-12-02'