select CONVERT(VARCHAR(50), GETDATE(), 1)

0 Sep 27 2011 8:53AM               
1 09/27/11                         
2 11.09.27                         
3 2027-09-11
4 01.01.12                         
5 2001-01-12
6 01-Jan-12
7 01-Jan-12
8 1:01:01
9 Jan 01 2012 1:01:01:001AM        
10 2001-01-12
11 2012-01-01
12 120101
13 01 Jan 2012 01:01:01:001         
14 01:01:01:001                     
20 2012-01-01 1:01
21 01:01.0
22 2001-01-12 1:01
23 2012-01-01
24 1:01:01
25 01:01.0
100 Jan 1 2012 1:01AM                
101 01/01/2012                       
102 2012.01.01                       
103 01/01/2012                       
104 01.01.2012                       
105 01-01-2012                       
106 01-Jan-12
107 01-Jan-12
108 1:01:01
109 Jan 01 2012 1:01:01:001AM        
110 01-01-2012                       
111 2012-01-01
112 20120101
113 01 Jan 2012 01:01:01:001         
114 01:01:01:001                     
120 2012-01-01 1:01
121 01:01.0
126 2012-01-01T01:01:01.001          
127 2012-01-01T01:01:01.001          
130 01 ???? 1432 1:01:01:001AM       
131 01/01/1432 1:01:01:001AM         
Posted by 홍상길 홍상길

댓글을 달아 주세요


블로그 이미지
홍상길

공지사항

Yesterday17
Today0
Total294,940

달력

 « |  » 2019.12
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        

최근에 달린 댓글

글 보관함