SQL get last 6 month data

Not only 6 month you can get data as you want.

 SELECT *  
 From PIS.dbo.PIS_tblEmployeeGenInfo  
 WHERE dtJoiningDate > DATEADD(m, -6, current_timestamp)