Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/2/3 6:44:05 如何找出相同月日记录_[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())
赞