SQL Server中提供了大量的日期格式化样式
select CONVERT(varchar(50),GETDATE(),0) 07 16 2018 11:00AM
select CONVERT(varchar(50),GETDATE(),1) 07/16/18
select CONVERT(varchar(50),GETDATE(),2) 18.07.16
select CONVERT(varchar(50),GETDATE(),3) 16/07/18
select CONVERT(varchar(50),GETDATE(),4) 16.07.18
select CONVERT(varchar(50),GETDATE(),5) 16-07-18
select CONVERT(varchar(50),GETDATE(),6) 16 07 18
select CONVERT(varchar(50),GETDATE(),7) 07 16, 18
select CONVERT(varchar(50),GETDATE(),8) 11:04:37
select CONVERT(varchar(50),GETDATE(),9) 07 16 2018 11:05:08:140AM
select CONVERT(varchar(50),GETDATE(),10) 07-16-18
select CONVERT(varchar(50),GETDATE(),11) 18/07/16
select CONVERT(varchar(50),GETDATE(),12) 180716
select CONVERT(varchar(50),GETDATE(),13) 16 07 2018 11:06:56:437
select CONVERT(varchar(50),GETDATE(),14) 11:07:24:327
select CONVERT(varchar(50),GETDATE(),20) 2018-07-16 11:08:35
select CONVERT(varchar(50),GETDATE(),21) 2018-07-16 11:09:07.817
select CONVERT(varchar(50),GETDATE(),22) 07/16/18 11:09:30 AM
select CONVERT(varchar(50),GETDATE(),23) 2018-07-16
select CONVERT(varchar(50),GETDATE(),24) 11:10:21
select CONVERT(varchar(50),GETDATE(),25) 2018-07-16 11:10:46.053
select CONVERT(varchar(50),GETDATE(),100) 07 16 2018 11:11AM
select CONVERT(varchar(50),GETDATE(),101) 07/16/2018
select CONVERT(varchar(50),GETDATE(),102) 2018.07.16
select CONVERT(varchar(50),GETDATE(),103) 2018.07.16
select CONVERT(varchar(50),GETDATE(),104) 16.07.2018
select CONVERT(varchar(50),GETDATE(),105) 16-07-2018
select CONVERT(varchar(50),GETDATE(),106) 16 07 2018
select CONVERT(varchar(50),GETDATE(),107) 07 16, 2018
select CONVERT(varchar(50),GETDATE(),108) 11:15:20
select CONVERT(varchar(50),GETDATE(),109) 07 16 2018 11:15:40:837AM
select CONVERT(varchar(50),GETDATE(),110) 07-16-2018
select CONVERT(varchar(50),GETDATE(),111) 2018/07/16
select CONVERT(varchar(50),GETDATE(),112) 20180716
select CONVERT(varchar(50),GETDATE(),113) 16 07 2018 11:17:02:440
select CONVERT(varchar(50),GETDATE(),114) 11:17:24:437
select CONVERT(varchar(50),GETDATE(),115) 11:17:24:437
select CONVERT(varchar(50),GETDATE(),120) 2018-07-16 11:19:05
select CONVERT(varchar(50),GETDATE(),121) 2018-07-16 11:19:27.690
select CONVERT(varchar(50),GETDATE(),126) 2018-07-16T11:20:38.507
select CONVERT(varchar(50),GETDATE(),127) 2018-07-16T11:21:03.043
select CONVERT(varchar(50),GETDATE(),130) 4 ?? ?????? 1439 11:21:31:637AM
select CONVERT(varchar(50),GETDATE(),131) 4/11/1439 11:22:05:673AM