直接上结果把,比较容易看,以方便以后工作中会遇到时选取所需。
第一行为sql文,第二段为结果
Select CONVERT(varchar(100), GETDATE(), 23)-03-19Select CONVERT(varchar(100), GETDATE(), 0)Mar 19 5:32AMSelect CONVERT(varchar(100), GETDATE(), 1)03/19/19Select CONVERT(varchar(100), GETDATE(), 2)19.03.19Select CONVERT(varchar(100), GETDATE(), 3)19/03/19Select CONVERT(varchar(100), GETDATE(), 4)19.03.19Select CONVERT(varchar(100), GETDATE(), 5)19-03-19Select CONVERT(varchar(100), GETDATE(), 6)19 Mar 19Select CONVERT(varchar(100), GETDATE(), 7)Mar 19, 19Select CONVERT(varchar(100), GETDATE(), 8)05:34:36Select CONVERT(varchar(100), GETDATE(), 9)Mar 19 5:34:59:847AMSelect CONVERT(varchar(100), GETDATE(), 10)03-19-19Select CONVERT(varchar(100), GETDATE(), 11)19/03/19Select CONVERT(varchar(100), GETDATE(), 12)190319Select CONVERT(varchar(100), GETDATE(), 13)19 Mar 05:36:16:827Select CONVERT(varchar(100), GETDATE(), 14)05:36:16:827Select CONVERT(varchar(100), GETDATE(), 20)-03-19 05:36:30Select CONVERT(varchar(100), GETDATE(), 21)-03-19 05:36:30.570Select CONVERT(varchar(100), GETDATE(), 22)03/19/19 5:36:42 AMSelect CONVERT(varchar(100), GETDATE(), 23)-03-19Select CONVERT(varchar(100), GETDATE(), 24)05:36:56Select CONVERT(varchar(100), GETDATE(), 25)-03-19 05:36:56.430Select CONVERT(varchar(100), GETDATE(), 100)Mar 19 5:37AMSelect CONVERT(varchar(100), GETDATE(), 101)03/19/Select CONVERT(varchar(100), GETDATE(), 102).03.19Select CONVERT(varchar(100), GETDATE(), 103)19/03/Select CONVERT(varchar(100), GETDATE(), 104)19.03.Select CONVERT(varchar(100), GETDATE(), 105)19-03-Select CONVERT(varchar(100), GETDATE(), 106)19 Mar Select CONVERT(varchar(100), GETDATE(), 107)Mar 19, Select CONVERT(varchar(100), GETDATE(), 108)05:38:06Select CONVERT(varchar(100), GETDATE(), 109)Mar 19 5:38:06:627AMSelect CONVERT(varchar(100), GETDATE(), 110)03-19-Select CONVERT(varchar(100), GETDATE(), 111)/03/19Select CONVERT(varchar(100), GETDATE(), 112)0319Select CONVERT(varchar(100), GETDATE(), 113)19 Mar 05:38:32:710Select CONVERT(varchar(100), GETDATE(), 114)05:38:48:527Select CONVERT(varchar(100), GETDATE(), 120)-03-19 05:38:48Select CONVERT(varchar(100), GETDATE(), 121)-03-19 05:39:03.533Select CONVERT(varchar(100), GETDATE(), 126)-03-19T05:39:03.533