반응형
| CONVERT 형식 | 결과값 |
| SELECT CONVERT(VARCHAR,GETDATE(),1) | 09/07/21 |
| SELECT CONVERT(VARCHAR,GETDATE(),2) | 21.09.07 |
| SELECT CONVERT(VARCHAR,GETDATE(),3) | 2007-09-21 |
| SELECT CONVERT(VARCHAR,GETDATE(),4) | 07.09.21 |
| SELECT CONVERT(VARCHAR,GETDATE(),5) | 2007-09-21 |
| SELECT CONVERT(VARCHAR,GETDATE(),8) | 14:20:06 |
| SELECT CONVERT(VARCHAR,GETDATE(),9) | 09 7 2021 2:20:06:410PM |
| SELECT CONVERT(VARCHAR,GETDATE(),13) | 07 09 2021 14:20:06:410 |
| SELECT CONVERT(VARCHAR,GETDATE(),14) | 14:20:06:410 |
| SELECT CONVERT(VARCHAR,GETDATE(),20) | 2021-09-07 14:20 |
| SELECT CONVERT(VARCHAR,GETDATE(),21) | 20:06.4 |
| SELECT CONVERT(VARCHAR,GETDATE(),22) | 2009-07-21 14:20 |
| SELECT CONVERT(VARCHAR,GETDATE(),23) | 2021-09-07 |
| SELECT CONVERT(VARCHAR,GETDATE(),25) | 20:06.4 |
| SELECT CONVERT(VARCHAR,GETDATE(),101) | 09/07/2021 |
| SELECT CONVERT(VARCHAR,GETDATE(),102) | 2021.09.07 |
| SELECT CONVERT(VARCHAR,GETDATE(),103) | 07/09/2021 |
| SELECT CONVERT(VARCHAR,GETDATE(),104) | 07.09.2021 |
| SELECT CONVERT(VARCHAR,GETDATE(),105) | 07-09-2021 |
| SELECT CONVERT(VARCHAR,GETDATE(),111) | 2021-09-07 |
| SELECT CONVERT(VARCHAR,GETDATE(),112) | 20210907 |
| SELECT CONVERT(VARCHAR,GETDATE(),120) | 2021-09-07 14:20 |
| SELECT CONVERT(VARCHAR,GETDATE(),121) | 20:06.4 |
| SELECT CONVERT(VARCHAR(6),GETDATE(),112) | 202109 |
| SELECT CONVERT(VARCHAR(4),GETDATE(),112) | 2021 |
| SELECT CONVERT(VARCHAR,GETDATE()-1,112) | 20210906 |
현재일자 2021년 09월 07일 기준 결과 쿼리
반응형
나남나여
일상 제품리뷰와 맛집/여행/사진을 좋아하고 IT 관련 프로그래밍 초급 & 고급 정보를 공유하는 블로그