Ways of getting different different time formats

select convert(varchar(8), getdate(), 108) as time_only;

select convert(varchar(5),getdate(),108) time_only;

select substring(convert(varchar, getdate(), 114),1,5) time_only;

select convert(char(5), getdate(),108) time_only;

select convert(varchar, getdate(), 114) as [hh:mi(24h)]

select ltrim(right(convert(varchar(20),getdate(),100),7)) '12 hour format';

select right(convert(char(20),getdate(),0),7) '12 hour format';

select right(convert(char(20),getdate(),100),7) '12 hour format';

select convert(nvarchar,cast(getdate()as time),100);

select convert(time,getdate()) as hour_minute_second;

select cast(getdate() as time) as hour_minute_second;