如果是SQL SERVER,试试select * from sometable where datepart(year,dateField) = 2002select * from sometable where datepart(year,dateField) = 2002 and datepart(month,dateField) = 5select * from sometable where datepart(year,dateField) = 2002 and datepart(month,dateField) = 5 and datepart(day,dateField) = 3orselect * from sometable where convert(varchar(10),dateField, 110) = '05-03-2002'
可是我用的是access啊,能用m_strFilter吗? 能该怎样写?
我想saucer(思归) 应该是比较合适的: select * from sometable where datepart(year,dateField) = 2002 and datepart(month,dateField) = 5 and datepart(day,dateField) = 3
from sometable
where datepart(year,dateField) = 2002select *
from sometable
where datepart(year,dateField) = 2002 and datepart(month,dateField) = 5select *
from sometable
where datepart(year,dateField) = 2002 and datepart(month,dateField) = 5 and datepart(day,dateField) = 3orselect *
from sometable
where convert(varchar(10),dateField, 110) = '05-03-2002'
能该怎样写?
select *
from sometable
where datepart(year,dateField) = 2002 and datepart(month,dateField) = 5 and datepart(day,dateField) = 3