MSSQL - 날짜 형식 바꾸기, Convert 결과값

출처 : http://blog.naver.com/PostView.nhn?blogId=krpower&logNo=150125503189&beginTime=0&jumpingVid=&from=search&redirect=Log&widgetTypeCall=true&topReferer=http%3A%2F%2Fsearch.naver.com%2Fsearch.naver%3Fsm%3Dtab_hty.top%26where%3Dnexearch%26ie%3Dutf8%26query%3Dmssql%2B%25EB%2582%25A0%25EC%25A7%259C%26x%3D0%26y%3D0

 

 

CONVERT를 사용하여 날짜 형식을 바꾸는 일은 상당히 많은데..

매번 기억이 잘 안나서 검색해야되서 귀차나서 정리 고고고!

함수	결과값
CONVERT(VARCHAR, GETDATE(), 1)	10/04/11
CONVERT(VARCHAR, GETDATE(), 2)	11.10.04
CONVERT(VARCHAR, GETDATE(), 3)	04/10/11
CONVERT(VARCHAR, GETDATE(), 4)	04.10.11
CONVERT(VARCHAR, GETDATE(), 5)	04-10-11
CONVERT(VARCHAR, GETDATE(), 8)	14:35:29
CONVERT(VARCHAR, GETDATE(), 9)	10 04 2011 2:35:29:247PM
CONVERT(VARCHAR, GETDATE(), 13)	04 10 2011 14:35:29:247
CONVERT(VARCHAR, GETDATE(), 14)	14:35:29:247
CONVERT(VARCHAR, GETDATE(), 20)	2011-10-04 14:35:29
CONVERT(VARCHAR, GETDATE(), 21)	2011-10-04 14:35:29.247
CONVERT(VARCHAR, GETDATE(), 22)	10/04/11 2:35:29 PM
CONVERT(VARCHAR, GETDATE(), 23)	2011-10-04
CONVERT(VARCHAR, GETDATE(), 25)	2011-10-04 14:35:29
CONVERT(VARCHAR, GETDATE(),101)	10/04/2011
CONVERT(VARCHAR, GETDATE(),102)	2011.10.01
CONVERT(VARCHAR, GETDATE(),103)	04/10/2011
CONVERT(VARCHAR, GETDATE(),104)	04.10.2011
CONVERT(VARCHAR, GETDATE(),105)	04-10.2011
CONVERT(VARCHAR, GETDATE(),111)	2011/10/04
CONVERT(VARCHAR, GETDATE(),112)	20111004
CONVERT(VARCHAR, GETDATE(),120)	2011-10-04 14:35:29
CONVERT(VARCHAR, GETDATE(),121)	2011-10-04 14:35:29.247

다른 결과값들도 있지만, 일단 내가 자주 사용하는 아이로만 정리완료!!!

 

 

Ex) select CONVERT(VARCHAR(20), 날짜필드명 , 20) as 필드명 from 테이블명