J

MSSQL 날짜 타입 변환

0 Feb 22 2006 4:26PM CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0)
1 02/22/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1)
2 06.02.22 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2)
3 22/02/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3)
4 22.02.06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4)
5 22-02-06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5)
6 22 Feb 06 CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6)
7 Feb 22, 06 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7)
8 16:26:08 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8)
9 Feb 22 2006 4:26:08:020PM CONVERT(CHAR(26), CURRENT_TIMESTAMP, 9)
10 02-22-06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10)
11 06/02/22 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11)
12 060222 CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12)
13 22 Feb 2006 16:26:08:020 CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13)
14 16:26:08:037 CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14)
20 2006-02-22 16:26:08 CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20)
21 2006-02-22 16:26:08.037 CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21)
22 02/22/06 4:26:08 PM CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22)
23 2006-02-22 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 23)
24 16:26:08 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 24)
25 2006-02-22 16:26:08.037 CONVERT(CHAR(23), CURRENT_TIMESTAMP, 25)
100 Feb 22 2006 4:26PM CONVERT(CHAR(19), CURRENT_TIMESTAMP, 100)
101 02/22/2006 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 101)
102 2006.02.22 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 102)
103 22/02/2006 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 103)
104 22.02.2006 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 104)
105 22-02-2006 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 105)
106 22 Feb 2006 CONVERT(CHAR(11), CURRENT_TIMESTAMP, 106)
107 Feb 22, 2006 CONVERT(CHAR(12), CURRENT_TIMESTAMP, 107)
108 16:26:08 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 108)
109 Feb 22 2006 4:26:08:067PM CONVERT(CHAR(26), CURRENT_TIMESTAMP, 109)
110 02-22-2006 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 110)
111 2006/02/22 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 111)
112 20060222 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 112)
113 22 Feb 2006 16:26:08:067 CONVERT(CHAR(24), CURRENT_TIMESTAMP, 113)
114 16:26:08:067 CONVERT(CHAR(12), CURRENT_TIMESTAMP, 114)
120 2006-02-22 16:26:08 CONVERT(CHAR(19), CURRENT_TIMESTAMP, 120)
121 2006-02-22 16:26:08.080 CONVERT(CHAR(23), CURRENT_TIMESTAMP, 121)
126 2006-02-22T16:26:08.080 CONVERT(CHAR(23), CURRENT_TIMESTAMP, 126)
127 2006-02-22T16:26:08.080 CONVERT(CHAR(23), CURRENT_TIMESTAMP, 127)
130 24 ???? 1427 4:26:08:080PM CONVERT(CHAR(32), CURRENT_TIMESTAMP, 130)
131 24/01/1427 4:26:08:080PM CONVERT(CHAR(25), CURRENT_TIMESTAMP, 131)

망헐 숫자로 해놓으면 아냐?<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 16:46:12 기타에서 이동 됨]</div>

댓글 1개

F1 눌러서 . msdn 봐야죠 ㅋㅋ. 별 수 있나요 ..
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
08-10-30 조회 2,728
08-10-30 조회 2,826
08-10-20 조회 2,553
08-10-11 조회 2,458
08-09-20 조회 4,199
08-09-20 조회 2,875
08-09-18 조회 2,756
08-09-18 조회 3,454
08-09-17 조회 3,321
08-09-05 조회 4,653
08-09-03 조회 2,788
08-08-18 조회 2,914
08-08-17 조회 2,656
08-08-13 조회 3,427
08-07-30 조회 3,491
08-07-28 조회 4,370
08-07-22 조회 5,592
08-07-22 조회 4,088
08-07-10 조회 3,049
08-07-08 조회 3,115
08-06-30 조회 3,872
08-06-30 조회 3,358
08-06-30 조회 3,671
08-06-14 조회 2,754
08-06-11 조회 7,112
08-06-05 조회 3,320
08-05-20 조회 4,836
08-05-13 조회 4,181
08-05-08 조회 3,130
08-05-08 조회 5,284
08-04-25 조회 4,087
08-04-22 조회 4,557
08-04-21 조회 3,202
08-04-17 조회 2,579
08-04-17 조회 2,981
08-04-17 조회 2,274
08-04-17 조회 5,247
08-04-17 조회 4,562
08-04-17 조회 4,559
08-04-17 조회 3,342
08-04-17 조회 3,162
08-04-17 조회 3,649
08-04-17 조회 5,016
08-04-17 조회 5,159
08-04-17 조회 3,364
08-04-04 조회 4,631
08-04-04 조회 2,855
08-04-04 조회 2,601
08-04-04 조회 2,825
08-04-04 조회 2,565
08-04-04 조회 2,811
08-04-03 조회 2,695
08-04-03 조회 2,756
08-04-02 조회 3,075
08-04-02 조회 3,227
08-03-31 조회 3,114
08-03-26 조회 4,294
08-03-11 조회 2,989
08-03-11 조회 2,388
08-03-11 조회 2,404
08-03-07 조회 4,236
08-03-07 조회 3,335
08-03-06 조회 4,777
08-03-04 조회 3,417
08-02-19 조회 3,802
08-02-03 조회 3,428
08-01-18 조회 4,016
08-01-15 조회 3,468
08-01-12 조회 4,310
08-01-12 조회 3,887
08-01-12 조회 3,837
07-12-24 조회 3,134
07-11-30 조회 3,981
07-11-08 조회 5,033
07-11-06 조회 3,877
07-10-26 조회 5,026
07-10-24 조회 4,218
07-10-22 조회 3,593
07-10-19 조회 4,779
07-10-09 조회 4,920
07-10-09 조회 6,779
07-10-05 조회 3,113
07-10-05 조회 4,046
07-10-03 조회 7,555
07-10-03 조회 3,604
07-10-03 조회 2,956
07-10-03 조회 2,882
07-09-28 조회 4,729
07-09-27 조회 3,790
07-09-27 조회 3,245
07-09-13 조회 3,401
07-08-28 조회 3,470
07-08-04 조회 4,857
07-08-01 조회 5,551
07-08-01 조회 4,952
07-07-30 조회 5,478
07-07-29 조회 3,628
07-07-21 조회 3,442
07-07-18 조회 5,400
07-07-16 조회 3,199