Match Date Only

create function isDateMatch(@date1 datetime ,@date2 datetime )
returns int
as
begin

declare @ret_val int
set @ret_val=0


if year(@date1)=year(@date2) and month(@date1)=month(@date2) and day(@date1)=day(@date2)
begin
set @ret_val=1
end

return @ret_val

end