you can change format like this
Select Users.UserName, convert(varchar,Attendence.TimeIn,105) as TimeIn, convert(varchar,Attendence.TimeOut,105) as TimeOut from Users Inner Join Attendence on Users.UserID = Attendence.UserID
and you want just dd-mm-yy instead of dd-mm-yyyy then write just 5 instead of 105