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());
◎欢迎参与讨论，请在这里发表您的看法、交流您的观点。
Powered By Z-BlogPHP 1.7.3
Copyright 2024-2027 pukuimin Rights Reserved.
粤ICP备17100155号