SQL SERVER 获得当前系统时间

用GETDATE();获得当前系统时间

语句格式:Select CONVERT(varchar(100), GETDATE(), 类型所属数字)

0: 05 16 2008 10:57AM
1: 09/21/20
2: 08.05.16
3: 16/05/08
4: 16.05.08
5: 16-05-08
6: 16 05 08
7: 05 16, 08
8: 10:57:46
9: 05 16 2008 10:57:46:827AM
10: 05-16-08
11: 08/05/16
12: 080516
13: 16 05 2008 10:57:46:937
14: 10:57:46:967
20: 2008-05-16 10:57:47
21: 2008-05-16 10:57:47.157
22: 05/16/08 10:57:47 AM
23: 2008-05-16
24: 10:57:47
25: 2008-05-16 10:57:47.250

100: 05 16 2008 10:57AM
101: 05/16/2008
102: 2008.05.16
103: 16/05/2008
104: 16.05.2008
105: 16-05-2008
106: 16 05 2008
107: 05 16, 2008
108: 10:57:49
109: 05 16 2008 10:57:49:437AM
110: 05-16-2008
111: 2008/05/16
112: 20080516
113: 16 05 2008 10:57:49:513
114: 10:57:49:547


120: 2008-05-16 10:57:49
121: 2008-05-16 10:57:49.700


126: 2008-05-16T10:57:49.827


130:  4 ??? 1442  3:17:52:393PM
131: 4/02/1442  3:10:02:923PM


getDate():2008年01月08日 星期二 14:59

©️2020 CSDN 皮肤主题: 1024 设计师:上身试试 返回首页