SELECT Department , Employee , Days_of_Service , SOLUTION AS years_of_service --Basically, 356 days should = 1 year in this column From employee_list
SELECT Department , Employee , Days_of_Service , Days_of_Service/365 AS years_of_service , CAST(Days_of_Service AS float)/365 AS years_of_service_float From employee_list
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)