年月日格式:Select CONVERT(varchar(100), GETDATE(), 1): 06/08/16Select CONVERT(varchar(100), GETDATE(), 2): 16.06.08Select CONVERT(varchar(100), GETDATE(), 3): 16/06/08Select CONVERT(varchar(100), GETDATE(), 4): 16.06.08Select CONVERT(varchar(100), GETDATE(), 5): 16-06-08Select CONVERT(varchar(100), GETDATE(), 6): 16 06 08Select CONVERT(varchar(100), GETDATE(), 7): 06 08, 16Select CONVERT(varchar(100), GETDATE(), 10): 06-08-16Select CONVERT(varchar(100), GETDATE(), 11): 16/06/08Select CONVERT(varchar(100), GETDATE(), 12): 160608Select CONVERT(varchar(100), GETDATE(), 23): 2016-06-08Select CONVERT(varchar(100), GETDATE(), 101): 06/08/2016Select CONVERT(varchar(100), GETDATE(), 102): 2016.06.08Select CONVERT(varchar(100), GETDATE(), 103): 08/06/2016Select CONVERT(varchar(100), GETDATE(), 104): 08.06.2016Select CONVERT(varchar(100), GETDATE(), 105): 08-06-2016Select CONVERT(varchar(100), GETDATE(), 106): 08 06 2016Select CONVERT(varchar(100), GETDATE(), 107): 06 08, 2016Select CONVERT(varchar(100), GETDATE(), 110): 06-08-2016Select CONVERT(varchar(100), GETDATE(), 111): 2016/06/08Select CONVERT(varchar(100), GETDATE(), 112): 20160608
年月日+时间格式:Select CONVERT(varchar(100), GETDATE(), 13): 08 06 2016 18:12:51:097Select CONVERT(varchar(100), GETDATE(), 20): 2016-06-08 18:13:08Select CONVERT(varchar(100), GETDATE(), 21): 2016-06-08 18:13:17.890Select CONVERT(varchar(100), GETDATE(), 0): 06 8 2016 6:10PMSelect CONVERT(varchar(100), GETDATE(), 9): 06 8 2016 6:12:05:990PMSelect CONVERT(varchar(100), GETDATE(), 22): 06/08/16 6:13:25 PMSelect CONVERT(varchar(100), GETDATE(), 25): 2016-06-08 18:13:52.293Select CONVERT(varchar(100), GETDATE(), 100): 06 8 2016 6:14PMSelect CONVERT(varchar(100), GETDATE(), 109): 06 8 2016 6:15:17:573PMSelect CONVERT(varchar(100), GETDATE(), 113): 08 06 2016 18:15:46:733Select CONVERT(varchar(100), GETDATE(), 120): 2016-06-08 18:16:01Select CONVERT(varchar(100), GETDATE(), 121): 2016-06-08 18:16:09.863Select CONVERT(varchar(100), GETDATE(), 126): 2016-06-08T18:16:16.520Select CONVERT(varchar(100), GETDATE(), 130): 3 ????? 1437 6:16:24:440PMSelect CONVERT(varchar(100), GETDATE(), 131): 3/09/1437 6:16:32:197PM
时间:Select CONVERT(varchar(100), GETDATE(), 8): 18:11:58Select CONVERT(varchar(100), GETDATE(), 24): 18:13:42Select CONVERT(varchar(100), GETDATE(), 108): 18:15:10Select CONVERT(varchar(100), GETDATE(), 14): 18:12:58:887Select CONVERT(varchar(100), GETDATE(), 114): 18:15:53:937