sqlserver datetime部分转换格式
sqlserver convert(datetime, getdate(), index)
date index
03/02/11 1
11.03.02 2
02/03/11 3
02.03.11 4
02-03-11 5
02 03 11 6
03 02, 11 7
15:24:00 8
03 2 2011 3:24:00:310PM 9
03-02-11 10
11/03/02 11
110302 12
02 03 2011 15:24:00:310 13
15:24:00:310 14
2011-03-02 15:28:26.367 21
03/02/11 3:28:26 PM 22
2011-03-02 23
15:28:26 24
2011-03-02 15:28:26.367 25
03 2 2011 3:29PM 100
03/02/2011 101
2011.03.02 102
02/03/2011 103
02.03.2011 104
02-03-2011 105
02 03 2011 106
03 02, 2011 107
15:29:27 108
03 2 2011 3:29:27:147PM 109
03-02-2011 110
2011/03/02 111
20110302 112
02 03 2011 15:29:27:147 113
15:29:27:147 114