작성일 : 12-05-16 10:12
|
[MsSQL] 년월일 2012-05-16 형식
|
 |
|
글쓴이 :
조형래
 조회 : 4,849
|
convert(varchar(10),GETDATE(),121)
select CONVERT(VARCHAR(50), GETDATE(), 1)
0 Sep 27 2011 8:53AM
1 09/27/11
2 11.09.27
3 27/09/11
4 27.09.11
5 27-09-11
6 27 Sep 11
7 Sep 27, 11
8 08:53:10
9 Sep 27 2011 8:53:10:273AM
10 09-27-11
11 11/09/27
12 110927
13 27 Sep 2011 08:53:10:273
14 08:53:10:273
20 2011-09-27 08:53:10
21 2011-09-27 08:53:10.280
22 09/27/11 8:53:10 AM
23 2011-09-27
24 08:53:10
25 2011-09-27 08:53:10.280
100 Sep 27 2011 8:53AM
101 09/27/2011
102 2011.09.27
103 27/09/2011
104 27.09.2011
105 27-09-2011
106 27 Sep 2011
107 Sep 27, 2011
108 08:53:10
109 Sep 27 2011 8:53:10:290AM
110 09-27-2011
111 2011/09/27
112 20110927
113 27 Sep 2011 08:53:10:290
114 08:53:10:290
120 2011-09-27 08:53:10
121 2011-09-27 08:53:10.290
126 2011-09-27T08:53:10.293
127 2011-09-27T08:53:10.293
130 29 ???? 1432 8:53:10:293AM
131 29/10/1432 8:53:10:293AM
|
|
1050
