2012年4月24日
SQL 工齡計算
摘要： select EmployeesList.*,datediff(year,EmployeesList.EmployeeEnterDate,getdate()) as 'InJobTime' from EmployeesList---Geovin Du 塗聚文select EmployeesList.*,datediff(month,EmployeesList.EmployeeEnterDate,getdate()) as 'InJobTime' from EmployeesListselect EmployeesList.*,datediff(month,Emp 阅读全文
posted @ 2012-04-24 19:14 ®Geovin Du Dream Park™ 阅读(615) 评论(0) 推荐(0)