sql按时间条件查询如何写

用between有个问题就是最后一天查询不到，也就是他的范围是[2011-1-1, 2011-2-1)也可以直接用>=和<=来查询，比如：select * from table where 时间>='2011-1-1' and 时间<'2011-2-1'或者select * from table where 时间 between '2011-1-1' and '2011-2-1'

dim medate as string

medate = rtrim(t_date.text)

本月：

sql = "select * from table where month(inputdate) = month('"+medate+"')"

本年度： 

sql = "select * from table where year(inputdate) = year('"+medate+"')"

本季度：

dim stdt as string

dim eddt as string

sql = "select * from table where inputdate = '"+stdt+"' and '"+eddt+"'"

这样？

用between呀

用between and