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 (时间类型)
|
|