SQL_Server_日期转换成字符串

Feb 22 2006 4:26PM 02/22/06 06.02.22 22/02/06 22.02.06 22-02-06 22 Feb 06 Feb 22, 06 16:26:08

Feb 22 2006 4:26:08:020PM 02-22-06 06/02/22 060222

22 Feb 2006 16:26:08:020 16:26:08:037 2006-02-22 16:26:08 2006-02-22 16:26:08.037 02/22/06 4:26:08 PM 2006-02-22 16:26:08

2006-02-22 16:26:08.037

CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5) CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8 ) CONVERT(CHAR(26), CURRENT_TIMESTAMP, 9) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11) CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12) CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13) CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14) CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20) CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21) CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 23) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 24) CONVERT(CHAR(23), CURRENT_TIMESTAMP, 25)

100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 120 121 126 127 130 131

Feb 22 2006 4:26PM 02/22/2006 2006.02.22 22/02/2006 22.02.2006 22-02-2006 22 Feb 2006 Feb 22, 2006 16:26:08

Feb 22 2006 4:26:08:067PM 02-22-2006 2006/02/22 20060222

22 Feb 2006 16:26:08:067 16:26:08:067 2006-02-22 16:26:08 2006-02-22 16:26:08.080 2006-02-22T16:26:08.080 2006-02-22T16:26:08.080 24 ???? 1427 4:26:08:080PM 24/01/1427 4:26:08:080PM

CONVERT(CHAR(19), CURRENT_TIMESTAMP, 100) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 101) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 102) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 103) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 104) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 105) CONVERT(CHAR(11), CURRENT_TIMESTAMP, 106) CONVERT(CHAR(12), CURRENT_TIMESTAMP, 107) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 108) CONVERT(CHAR(26), CURRENT_TIMESTAMP, 109) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 110) CONVERT(CHAR(10), CURRENT_TIMESTAMP, 111) CONVERT(CHAR(8), CURRENT_TIMESTAMP, 112) CONVERT(CHAR(24), CURRENT_TIMESTAMP, 113) CONVERT(CHAR(12), CURRENT_TIMESTAMP, 114) CONVERT(CHAR(19), CURRENT_TIMESTAMP, 120) CONVERT(CHAR(23), CURRENT_TIMESTAMP, 121) CONVERT(CHAR(23), CURRENT_TIMESTAMP, 126) CONVERT(CHAR(23), CURRENT_TIMESTAMP, 127) CONVERT(CHAR(32), CURRENT_TIMESTAMP, 130) CONVERT(CHAR(25), CURRENT_TIMESTAMP, 131)