SQl语句中日期时间的转换

当前日期时间：2018-09-11 15:34:43
select CONVERT(varchar,GETDATE(),0) 09 11 2018 3:28PM
select CONVERT(varchar,GETDATE(),1) 09/11/18
select CONVERT(varchar,GETDATE(),2) 18.09.11
select CONVERT(varchar,GETDATE(),3) 11/09/18
select CONVERT(varchar,GETDATE(),4) 11.09.18
select CONVERT(varchar,GETDATE(),5) 11-09-18
select CONVERT(varchar,GETDATE(),6) 11 09 18
select CONVERT(varchar,GETDATE(),7) 09 11, 18
select CONVERT(varchar,GETDATE(),8) 15:31:56
select CONVERT(varchar,GETDATE(),9) 09 11 2018 3:32:24:523PM
select CONVERT(varchar,GETDATE(),10) 09-11-18
select CONVERT(varchar,GETDATE(),11) 18/09/11
select CONVERT(varchar,GETDATE(),12) 180911
select CONVERT(varchar,GETDATE(),13) 11 09 2018 15:33:36:623
select CONVERT(varchar,GETDATE(),14) 15:33:51:850

select CONVERT(varchar,GETDATE(),20) 2018-09-11 15:34:43
select CONVERT(varchar,GETDATE(),21) 2018-09-11 15:35:54.200
select CONVERT(varchar,GETDATE(),22) 09/11/18 3:36:21 PM
select CONVERT(varchar,GETDATE(),23) 2018-09-11
select CONVERT(varchar,GETDATE(),24) 15:36:50
select CONVERT(varchar,GETDATE(),25) 2018-09-11 15:36:59.847

select CONVERT(varchar,GETDATE(),100) 09 11 2018 3:37PM
select CONVERT(varchar,GETDATE(),101) 09/11/2018
select CONVERT(varchar,GETDATE(),102) 2018.09.11
select CONVERT(varchar,GETDATE(),103) 11/09/2018
select CONVERT(varchar,GETDATE(),104) 11.09.2018
select CONVERT(varchar,GETDATE(),105) 11-09-2018
select CONVERT(varchar,GETDATE(),106) 11 09 2018
select CONVERT(varchar,GETDATE(),107) 09 11, 2018
select CONVERT(varchar,GETDATE(),108) 15:40:10
select CONVERT(varchar,GETDATE(),109) 09 11 2018 3:40:27:500PM
select CONVERT(varchar,GETDATE(),110) 09-11-2018
select CONVERT(varchar,GETDATE(),111) 2018/09/11
select CONVERT(varchar,GETDATE(),112) 20180911
select CONVERT(varchar,GETDATE(),113) 11 09 2018 15:41:18:990
select CONVERT(varchar,GETDATE(),114) 15:41:40:700

select CONVERT(varchar,GETDATE(),120) 2018-09-11 15:41:58
select CONVERT(varchar,GETDATE(),121) 2018-09-11 15:42:10.650