Set Time Format:-

declare @mydate datetime
set @mydate= getdate()
select convert(varchar,@mydate, 101) + right(convert(varchar,@mydate,100),8)