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.5
Copyright 2024-2029 pukuimin Rights Reserved.
粤ICP备17100155号-1