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,187건
+
제목 글쓴이 날짜 조회
10-11-17 조회 2,324
10-11-16 조회 2,628
10-11-16 조회 2,128
10-11-16 조회 2,369
10-11-15 조회 2,838
10-11-15 조회 2,347
10-11-15 조회 3,093
10-11-15 조회 2,113
10-11-15 조회 2,219
10-11-15 조회 2,773
10-11-15 조회 2,472
10-11-14 조회 2,130
10-11-14 조회 4,339
10-11-14 조회 2,667
10-11-14 조회 3,680
10-11-13 조회 3,503
10-11-13 조회 2,483
10-11-13 조회 3,701
10-11-12 조회 2,304
10-11-12 조회 2,697
10-11-11 조회 3,868
10-11-11 조회 2,087
10-11-11 조회 2,702
10-11-10 조회 2,927
10-11-10 조회 2,194
10-11-10 조회 2,550
10-11-10 조회 2,032
10-11-09 조회 3,371
10-11-09 조회 2,885
10-11-09 조회 2,217
10-11-09 조회 1,916
10-11-09 조회 1,986
10-11-09 조회 2,522
10-11-09 조회 2,487
10-11-08 조회 1,899
10-11-08 조회 1,785
10-11-08 조회 2,074
10-11-08 조회 2,075
10-11-08 조회 2,995
10-11-08 조회 1,916
10-11-08 조회 2,063
10-11-08 조회 2,026
10-11-08 조회 2,279
10-11-08 조회 3,044
10-11-07 조회 2,940
10-11-07 조회 1.6만
10-11-07 조회 4,513
10-11-06 조회 2,072
10-11-06 조회 2,080
10-11-06 조회 2,233
10-11-06 조회 2,008
10-11-06 조회 1,972
10-11-06 조회 1.3만
10-11-05 조회 2,565
10-11-05 조회 2,531
10-11-05 조회 2,672
10-11-04 조회 2,570
10-11-04 조회 1,926
10-11-04 조회 2,785
10-11-04 조회 2,311
10-11-04 조회 1,952
10-11-04 조회 2,127
10-11-04 조회 2,191
10-11-04 조회 2,767
10-11-04 조회 2,118
10-11-04 조회 2,094
10-11-04 조회 2,323
10-11-03 조회 2,095
10-11-03 조회 2,961
10-11-03 조회 2,681
10-11-03 조회 4,256
10-11-03 조회 2,962
10-11-03 조회 1,987
10-11-03 조회 1,937
10-11-02 조회 2,161
10-11-02 조회 2,776
10-11-02 조회 2,798
10-11-01 조회 1,999
10-11-01 조회 2,095
10-11-01 조회 2,380
10-11-01 조회 2,587
10-10-31 조회 2,360
10-10-31 조회 2,310
10-10-31 조회 2,577
10-10-30 조회 1,989
10-10-30 조회 1,962
10-10-30 조회 2,483
10-10-30 조회 1,983
10-10-29 조회 3,150
10-10-29 조회 3,735
10-10-29 조회 2,170
10-10-29 조회 2,250
10-10-29 조회 3,125
10-10-28 조회 2,346
10-10-28 조회 2,445
10-10-28 조회 2,841
10-10-28 조회 3,003
10-10-28 조회 3,263
10-10-27 조회 2,565
10-10-27 조회 3,297