按指定日期查询数据库

sql="select * from biao where DateDiff('d',date,#2006-2-15#)=0"

sql="select * from biao where DateDiff('m',date,#2006-2-15#)=0"

sql="select * from biao where DateDiff('y',date,#2006-2-15#)=0"

sql="select * from biao where DateDiff('m',date,date())=0"

sql="select * from biao where DateDiff('m',date,now())=0"

以上测试成功！

表名 biao

字段 date （时间类型）