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-05-15 조회 4,294
10-05-10 조회 2,984
10-04-29 조회 5,697
10-04-28 조회 3,902
10-04-17 조회 4,829
10-04-15 조회 3,277
10-04-04 조회 3,513
10-04-02 조회 2,806
10-03-23 조회 5,983
10-03-19 조회 5,522
10-03-05 조회 5,281
10-03-01 조회 6,955
10-02-27 조회 5,119
10-02-26 조회 3,515
10-02-23 조회 3,467
10-02-23 조회 3,622
10-02-19 조회 3,320
10-02-17 조회 5,730
10-02-17 조회 4,453
10-02-17 조회 3,880
10-02-12 조회 3,202
10-02-12 조회 3,541
10-02-12 조회 3,871
10-02-11 조회 3,009
10-02-11 조회 4,087
10-02-09 조회 3,388
10-02-09 조회 3,496
10-02-09 조회 3,194
10-02-09 조회 3,859
10-02-09 조회 3,129
10-02-09 조회 3,474
10-01-26 조회 3,586
10-01-25 조회 2,716
10-01-25 조회 2,815
10-01-23 조회 3,420
10-01-23 조회 6,932
10-01-20 조회 3,151
10-01-19 조회 3,630
10-01-13 조회 3,834
10-01-07 조회 3,019
10-01-07 조회 2,803
10-01-07 조회 3,776
10-01-07 조회 6,484
09-12-31 조회 3,776
09-12-27 조회 4,460
09-12-18 조회 3,258
09-12-14 조회 5,270
09-12-14 조회 6,153
09-12-06 조회 4,865
09-11-26 조회 3,782
09-11-24 조회 3,918
09-11-24 조회 4,343
09-11-23 조회 3,683
09-11-21 조회 7,039
09-11-20 조회 4,914
09-11-19 조회 2,829
09-11-19 조회 3,197
09-11-13 조회 6,663
09-11-11 조회 3,790
09-11-09 조회 4,812
09-11-09 조회 4,087
09-11-09 조회 2,981
09-11-04 조회 6,810
09-10-26 조회 3,943
09-10-10 조회 7,431
09-10-09 조회 3,444
09-10-08 조회 5,408
09-09-19 조회 4,475
09-09-15 조회 3,617
09-09-14 조회 3,646
09-09-11 조회 5,842
09-09-04 조회 4,897
09-08-31 조회 4,247
09-08-31 조회 4,455
09-08-30 조회 3,524
09-08-30 조회 3,281
09-08-30 조회 3,119
09-08-30 조회 2,805
09-08-30 조회 3,109
09-08-30 조회 3,337
09-08-30 조회 3,043
09-08-16 조회 6,369
09-08-14 조회 5,346
09-08-12 조회 3,310
09-08-12 조회 3,086
09-08-12 조회 3,800
09-07-24 조회 6,050
09-07-23 조회 5,110
09-07-22 조회 4,184
09-07-22 조회 5,759
09-07-22 조회 4,788
09-07-22 조회 2,928
09-07-21 조회 2,825
09-07-21 조회 3,462
09-07-19 조회 3,341
09-07-17 조회 4,050
09-07-17 조회 3,584
09-07-17 조회 2,848
09-07-15 조회 5,937
09-07-11 조회 3,019