[mssql] Convert 양식 설명

Sybase ASE 12.5.3 datetime 형식의 컬럼으로부터 Select 할때 convert 유형.

 

 

select COLMN_NAME                               2006-10-27 00:00:00.0
select CONVERT(VARCHAR, COLMN_NAME, 100)  ==> Oct 27 2006 12:00AM
select CONVERT(VARCHAR, COLMN_NAME, 101)  ==> 10/27/2006
select CONVERT(VARCHAR, COLMN_NAME, 102)  ==> 2006.10.27
select CONVERT(VARCHAR, COLMN_NAME, 103)  ==> 27/10/2006
select CONVERT(VARCHAR, COLMN_NAME, 104)  ==> 27.10.2006
select CONVERT(VARCHAR, COLMN_NAME, 105)  ==> 27-10-2006
select CONVERT(VARCHAR, COLMN_NAME, 106)  ==> 27 Oct 2006
select CONVERT(VARCHAR, COLMN_NAME, 107)  ==> Oct 27, 2006
select CONVERT(VARCHAR, COLMN_NAME, 108)  ==> 00:00:00
select CONVERT(VARCHAR, COLMN_NAME, 109)  ==> Oct 27 2006 12:00:00:000AM
select CONVERT(VARCHAR, COLMN_NAME, 110)  ==> 10-27-2006
select CONVERT(VARCHAR, COLMN_NAME, 111)  ==> 2006/10/27
select CONVERT(VARCHAR, COLMN_NAME, 112)  ==> 20061027
select CONVERT(VARCHAR, COLMN_NAME, 113)  ==> 2006/27/10
select CONVERT(VARCHAR, COLMN_NAME, 114)  ==> 10/2006/27
select CONVERT(VARCHAR, COLMN_NAME, 115)  ==> 27/2006/10

출처 Sybase 12.5.3 datetime 형식의 컬럼으로부터 Select 할때 convert 유형에 따른 결과값.|작성자 락쥐