sqlserver 사용량 변환

SqlServer에서는 函数应용 변환

CONVERT(varchar(100), GETDATE(), 0) 선택: 05 16 2006 10:57AM
CONVERT(varchar(100), GETDATE(), 1): 05/16/06
CONVERT(varchar(100), GETDATE(), 2) 선택: 06.05.16
CONVERT(varchar(100), GETDATE(), 3) 선택: 16/05 /06
CONVERT(varchar(100), GETDATE(), 4) 선택: 16.05.06
CONVERT(varchar(100), GETDATE(), 5) 선택: 16-05-06
선택 CONVERT(varchar(100), GETDATE(), 6): 16 05 06
CONVERT(varchar(100), GETDATE(), 7) 선택: 05 16, 06
CONVERT(varchar(100), GETDATE(), 8): 10:57:46
CONVERT 선택(varchar(100), GETDATE(), 9): 05 16 2006 10:57:46:827AM
CONVERT(varchar(100) 선택) , GETDATE(), 10): 05-16-06
CONVERT 선택(varchar(100), GETDATE(), 11): 06/05/16
CONVERT(varchar(100), GETDATE() 선택) , 12): 060516
CONVERT(varchar(100), GETDATE(), 13) 선택: 16 05 2006 10:57:46:937
CONVERT(varchar(100), GETDATE(), 14) 선택 : 10:57:46:967
CONVERT(varchar(100), GETDATE(), 20) 선택: 2006-05-16 10:57:47
CONVERT(varchar(100), GETDATE() 선택) , 21): 2006-05-16 10:57:47.157
CONVERT 선택(varchar(100), GETDATE(), 22): 05/16/06 10:57:47 AM
CONVERT(varchar 선택) (100), GETDATE(), 23): 2006-05-16
CONVERT(varchar(100), GETDATE(), 24) 선택: 10:57:47
CONVERT(varchar(100), GETDATE(), 25): 2006-05-16 10:57:47.250
CONVERT(varchar(100), GETDATE(), 100) 선택: 05 16 2006 10:57AM
CONVERT(varchar(100) 선택 ), GETDATE(), 101): 2006년 5월 16일
CONVERT(varchar(100), GETDATE(), 102) 선택: 2006.05.16
CONVERT(varchar(100), GETDATE(), 103): 16/05/2006
CONVERT 선택(varchar(100), GETDATE(), 104): 16.05.2006
CONVERT(varchar(100), GETDATE(), 105) 선택: 16-05 -2006
CONVERT 선택(varchar(100), GETDATE(), 106): 16 05 2006
CONVERT 선택(varchar(100), GETDATE(), 107): 05 16, 2006
CONVERT 선택 (varchar(100), GETDATE(), 108): 10:57:49
선택 CONVERT(varchar(100), GETDATE(), 109): 05 16 2006 10:57:49:437AM
선택 CONVERT(varchar(100), GETDATE(), 110): 05-16-2006
CONVERT(varchar(100), GETDATE(), 111) 선택: 2006/05/16
CONVERT(varchar( 100), GETDATE(), 112): 20060516
CONVERT(varchar(100), GETDATE(), 113) 선택: 16 05 2006 10:57:49:513
CONVERT(varchar(100), GETDATE(), 114): 10:57:49:547
CONVERT(varchar(100), GETDATE(), 120) 선택: 2006-05-16 10:57:49
CONVERT(varchar( 100), GETDATE(), 121): 2006-05-16 10:57:49.700
CONVERT(varchar(100), GETDATE(), 126): 2006-05-16T10:57:49.827
선택 CONVERT(varchar(100), GETDATE(), 130) 선택: 18 ???? ???????? 1427 10:57:49:907AM
CONVERT 선택(varchar(100), GETDATE(), 131): 18/04/1427 10:57:49:920AM

格式:
CONVERT (data_type,expression[,style])

설명:
此样式一般 현재 时间类型(datetime,smalldatetime)与字符串类型(nchar,nvarchar,char,varchar)
互转换的时候才用到.

例子:
SELECT CONVERT(varchar(30),getdate(),101) now
结果为:
now
------ ---------------------------------
|2001년 9월 15일

스타일 문자는 아래에 있습니다:

---------------------------------- --- ---------------------------------- --- -----------
스타일(2자리는 연도를 나타냄) | 스타일(4자리는 연도를 나타냄) | 입출력 형식
--- ----------- -------------------------- ----------- -------------------------- -----------
0                                                                                     | miAM (또는 PM)                                        ---------- ------------- ----------
1                                                                                                           ~ ------ ------------------ ------
2 | 102 ANSI ANSI yy-mm-dd yy-mm-dd
---------- ------------------ ------ ------------------ ------ -
3                                                                                                  
------ ---- ---------------- -------- ---------------- -----
4                                                                                                                                                                           ---------------------------- ----------------------- -----
5                                                                                                                                     🎜>--- ------------- ----------- ------------- ----------- -----
6                               |   106                            |    dd 월 yy                                      
------------------------------- ------------------------------------- --------------
7                              |   107                            |    월 dd,yy                                      
------------------ ------------------------------------- ---------------
8                               |   108                            |    hh:mm:ss                                      
----------------------------- ------------------------------------- ---
9                                |   109                            |    mon dd yyyy hh:mi:ss:mmmmAM(或PM)
--------------------------------- ------------------------------------- -------------------------
10                             |   110     미국                  |    mm-dd-yy                                      
----------------------------- ------------------------------------- ---
11                              |   111     日本                 |    yy/mm/dd                                     
----------------------------- ------------------------------------- ---
12                                                                                                              >------------ - -------- ----------------------------- -------- ----------
13 | 113 유럽 기본값 | dd mon yyyy hh:mi:ss:mmm (24시간 형식)
------ ------ ------------------ ------ ------------------------------- ---
14 | 114 | hh:mi:ss:mmm (24시간 형식)
------------ ------ ------------------ ------ ---------------
20                                                                     :ss(24시간 형식)
------ --------------------------------- ----------------- --------------------------------- ----------------- -
21                          |     121                     | yyyy-mm-dd hh:mi:ss:mmm(24时时)