如何找出相同月日记录_[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())