mithilesh kumar singh

Create table EmpJoin

(

EmpId int,

EmpName  varchar(50),

joinDate date

)

insert into EmpJoin(EmpId,Empname,joinDate)values(1001,'mithilesh','02-05-2015')

select * from EmpJoin

select DATEDIFF(WEEK,(select joinDate from EmpJoin),GETDATE())

Output: