0 | Feb 22 2006 4:26PM | CONVERT(CHAR(19), DATETIME, 0) |
1 | 02/22/06 | CONVERT(CHAR(8), DATETIME, 1) |
2 | 06.02.22 | CONVERT(CHAR(8), DATETIME, 2) |
3 | 22/02/06 | CONVERT(CHAR(8), DATETIME, 3) |
4 | 22.02.06 | CONVERT(CHAR(8), DATETIME, 4) |
5 | 22-02-06 | CONVERT(CHAR(8), DATETIME, 5) |
6 | 22 Feb 06 | CONVERT(CHAR(9), DATETIME, 6) |
7 | Feb 22, 06 | CONVERT(CHAR(10), DATETIME, 7) |
8 | 16:26:08 | CONVERT(CHAR(8), DATETIME, 8) |
9 | Feb 22 2006 4:26:08:020PM | CONVERT(CHAR(26), DATETIME, 9) |
10 | 02-22-06 | CONVERT(CHAR(8), DATETIME, 10) |
11 | 06/02/22 | CONVERT(CHAR(8), DATETIME, 11) |
12 | 060222 | CONVERT(CHAR(6), DATETIME, 12) |
13 | 22 Feb 2006 16:26:08:020 | CONVERT(CHAR(24), DATETIME, 13) |
14 | 16:26:08:037 | CONVERT(CHAR(12), DATETIME, 14) |
20 | 2006-02-22 16:26:08 | CONVERT(CHAR(19), DATETIME, 20) |
21 | 2006-02-22 16:26:08.037 | CONVERT(CHAR(23), DATETIME, 21) |
22 | 02/22/06 4:26:08 PM | CONVERT(CHAR(20), DATETIME, 22) |
23 | 2006-02-22 | CONVERT(CHAR(10), DATETIME, 23) |
24 | 16:26:08 | CONVERT(CHAR(8), DATETIME, 24) |
25 | 2006-02-22 16:26:08.037 | CONVERT(CHAR(23), DATETIME, 25) |
100 | Feb 22 2006 4:26PM | CONVERT(CHAR(19), DATETIME, 100) |
101 | 02/22/2006 | CONVERT(CHAR(10), DATETIME, 101) |
102 | 2006.02.22 | CONVERT(CHAR(10), DATETIME, 102) |
103 | 22/02/2006 | CONVERT(CHAR(10), DATETIME, 103) |
104 | 22.02.2006 | CONVERT(CHAR(10), DATETIME, 104) |
105 | 22-02-2006 | CONVERT(CHAR(10), DATETIME, 105) |
106 | 22 Feb 2006 | CONVERT(CHAR(11), DATETIME, 106) |
107 | Feb 22, 2006 | CONVERT(CHAR(12), DATETIME, 107) |
108 | 16:26:08 | CONVERT(CHAR(8), DATETIME, 108) |
109 | Feb 22 2006 4:26:08:067PM | CONVERT(CHAR(26), DATETIME, 109) |
110 | 02-22-2006 | CONVERT(CHAR(10), DATETIME, 110) |
111 | 2006/02/22 | CONVERT(CHAR(10), DATETIME, 111) |
112 | 20060222 | CONVERT(CHAR(8), DATETIME, 112) |
113 | 22 Feb 2006 16:26:08:067 | CONVERT(CHAR(24), DATETIME, 113) |
114 | 16:26:08:067 | CONVERT(CHAR(12), DATETIME, 114) |
120 | 2006-02-22 16:26:08 | CONVERT(CHAR(19), DATETIME, 120) |
121 | 2006-02-22 16:26:08.080 | CONVERT(CHAR(23), DATETIME, 121) |
126 | 2006-02-22T16:26:08.080 | CONVERT(CHAR(23), DATETIME, 126) |
127 | 2006-02-22T16:26:08.080 | CONVERT(CHAR(23), DATETIME, 127) |
130 | 24 ???? 1427 4:26:08:080PM | CONVERT(CHAR(32), DATETIME, 130) |
131 | 24/01/1427 4:26:08:080PM | CONVERT(CHAR(25), DATETIME, 131) |
Post List
2015년 1월 9일 금요일
MS-SQL Date Type Convert
피드 구독하기:
댓글 (Atom)
댓글 없음:
댓글 쓰기