• In reality, I have about 15 different formats. The one you asking looks:

     

    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

    I don't have #7 but it can be done similar way with CASE statement or conversion of datetime variable to varchar first based on the formatting parameter.

     

    I can make it Monday. I don't have SQL Server installed on my computer now.