create procedure USP_InsertStatusText(@Statustext char(150),@RecievedBy varchar(50),@Deliverydate datetime)
as
BEGIN
declare @date datetime

set @Deliverydate=  convert(varchar,@Deliverydate,1) --as [mm/dd/yy] from TB_StatusEntry

insert into TB_StatusText values(@Statustext,@RecievedBy,@Deliverydate)

END

declare @date datetime
set @date = CONVERT(varchar(10),getdate(),101)
select @date

--2010-06-09 00:00:00.000

declare @date varchar(10)
set @date = CONVERT(varchar(10),getdate(),101)
select @date

--06/09/2010