How to Get Employees Period in Company as per Employee Joini

Question

--How to Get Employees Period in Company as per Employee Joining Date Example I have a field Emp_Number Emp_Name Emp_JoiningDate Period Start Period End A-1 Alex 2013-07-14 2017-07-14 2018-07-14 A-2 Sachin 2017-08-14 2017-08-14 2018-08-14 Thanks Basit

Jothish Kumar · Answer

Hi check the below link you will get an idea. http://www.aspforums.net/Threads/143938/Calculate-employee-total-time-period-in-company-from-joining-date-to-end-date-in-SQL-Server/

Midhun T P · Answer

Hi Please try below query - SELECT Emp_NumberEmp_NameEmp_JoiningDate convert ( DATE  convert ( VARCHAR (4) YEAR (GETDATE()))+ '-' + convert ( VARCHAR (2) month ( Emp_JoiningDate ))+ '-' + convert ( VARCHAR (2) day ( Emp_JoiningDate ))) AS period_start  convert ( DATE  convert ( VARCHAR (4) YEAR (GETDATE())+1)+ '-' + convert ( VARCHAR (2) month ( Emp_JoiningDate ))+ '-' + convert ( VARCHAR (2) day ( Emp_JoiningDate ))) AS period_start from tablename

basit khan · Answer

Many Thanks what about sql express 2008

Midhun T P · Answer

Hi If you are using SQL server 2012 or higher you can use below query - SELECT Emp_NumberEmp_NameEmp_JoiningDateDATEFROMPARTS( YEAR (GETDATE()) month (Emp_JoiningDate) day (Emp_JoiningDate)) AS period_start DATEFROMPARTS( YEAR (GETDATE())+1 month (Emp_JoiningDate) day (Emp_JoiningDate)) AS period_end