关于"Select"查询日期的问题!好像很简单(50分)

M

mr.zy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-26

• #1

有一 Table1, date字段类型是日期型
id date
1 2002-10-21
2 2002-10-15
3 2002-11-1
问题:
如何将 10 月份的记录全部显示出来?
select * from table1 where date = '2002-10'; 对吗?
我要的有D6 + ADO + Access2000

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-26

• #2

select * from table1 where month(date)=10 and year(date)=2002

 

M

mr.zy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-26

• #3

太棒了,谢谢,注意收分!