DateTime format in SQL Server Query

select convert(varchar, getdate(), 1)
Output:- 12/30/06
select convert(varchar, getdate(), 2)
Output:- 06.12.30
select convert(varchar, getdate(), 3)
Output:- 30/12/06
select convert(varchar, getdate(), 4)
Output:-30.12.06
select convert(varchar, getdate(), 5)
Output:-30-12-06
select convert(varchar, getdate(), 6)
Output:-30 Dec 06
select convert(varchar, getdate(), 7)
Output:-Dec 30, 06
select convert(varchar, getdate(), 10)
Output:-12-30-06
select convert(varchar, getdate(), 11)
Output:-06/12/30
select convert(varchar, getdate(), 101)
Output:-12/30/2006
select convert(varchar, getdate(), 102)
Output:-2006.12.30
select convert(varchar, getdate(), 103)
Output:-30/12/2006
select convert(varchar, getdate(), 104)
Output:-30.12.2006
select convert(varchar, getdate(), 105)
Output:-30-12-2006
select convert(varchar, getdate(), 106)
Output:-30 Dec 2006
select convert(varchar, getdate(), 107)
Output:-Dec 30, 2006
select convert(varchar, getdate(), 110)
Output:-12-30-2006
select convert(varchar, getdate(), 111)
Output:-2006/12/30
select convert(varchar, getdate(), 8)
Output:-00:38:54
select convert(varchar, getdate(), 9)
Output:- Dec 30 2006 12:38:54:840AM
select convert(varchar, getdate(), 14)
Output:- 00:38:54:840