如何找出相同月日记录_[SQL Server教程]
主要是应用函数year,month,day,hour,minute,second
获得当前时间在MSSQL和ACCESS中,分别是getdate()和now()
MSSQL
select * from tablename where month(日期字段) = month(getdate()) and day(日期字段) = day getdate())
ACCESS
select * from tablename where month(日期字段) = month(now()) and day(日期字段) = day(now())