Oops, need change getdate to @datevar

IF (@dateformat = 7)

 begin

 set @converteddt =

  RIGHT('0' + right( convert(varchar, @datevar,100 ) ,7), 7)

  set @formatexists = 1

  end

IF (@dateformat = 8)

 begin

 set @converteddt =

  RIGHT('0' + CAST(DATEPART ( hh , @datevar ) AS VARCHAR(2)), 2) +  ':' +

  RIGHT('0' + CAST(DATEPART ( mi , @datevar ) AS VARCHAR(2)), 2)

  set @formatexists = 1

 end