공개 게시판 > 공부

Business
- Business
Information
- Information
Study
- IONIC REACT PHP GNU MySQL ASP .NET MsSQL Html CSS Script SEO DNS JQuery Eng
book
- book
free
- free

:: 글답변 ::

이 름

패스워드

이메일

홈페이지

옵 션

html

분 류

제 목

>
>
> 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
>

링크 #1

링크 #2

파일첨부

왼쪽의 글자를 입력하세요.