SQL Server datetime format conversion

Select CONVERT (varchar, GETDATE (), - )
2004-09- AOne :: ,

Select replace (replace (varchar, GETDATE (),),'-',"),'',"),':',‘‘)
20040912110608

Select CONVERT (varchar ((), GETDATE (),111 )
2004/09/ A

Select CONVERT (varchar ((), GETDATE (), the )
20040912

Select CONVERT (varchar ((), GETDATE (),102)
2004.09. A

Select CONVERT (varchar ((), GETDATE (),101)
09/12/2004

Select CONVERT (varchar ((), GETDATE (),103)
12/09/2004

Select CONVERT (varchar ((), GETDATE (),104)
12.09.2004

Select CONVERT (varchar ((), GETDATE (),105)
12-09-2004

Select CONVERT (varchar ((), GETDATE (),106)
A the2004

Select CONVERT (varchar ((), GETDATE (),107)
the,2004

Select CONVERT (varchar ((), GETDATE (),108 )
One :: ,

Select CONVERT (varchar ((), GETDATE (),109)
the A20041

Select CONVERT (varchar ((), GETDATE (),110)
09-12-2004

Select CONVERT (varchar (12), GETDATE (), 12 09 < Span style= "color: #000000;" >2004 1

select CONVERT (varchar ( 12), GETDATE (), 11: 06: 08.177

SQL Server datetime format conversion