SQL语句:
select * from salaryinfo where datepart(yyyy,salarydate) =datepart(yyyy,GetDate()) and datepart(mm,salarydate)=datepart(mm,GetDate()) and datepart(dd,salarydate)=datepart(dd,GetDate());
SQL语句:
select * from salaryinfo where datepart(yyyy,salarydate) =datepart(yyyy,GetDate()) and datepart(mm,salarydate)=datepart(mm,GetDate()) and datepart(dd,salarydate)=datepart(dd,GetDate());
◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。
评论列表: