[MSSQL] convert(varchar, getdate()) 번호별 정리

 

CONVERT 함수 : 데이터 타입을 변환해준다.

날짜를 문자타입으로 변환할 때 유용한데, 번호에 따라 출력 포맷을 변경할 수 있다.

select convert(varchar, getdate(), 1) AS date_1; -- 05/23/24
select convert(varchar, getdate(), 2) AS date_2; -- 24.05.23
select convert(varchar, getdate(), 3) AS date_3; -- 23/05/24
select convert(varchar, getdate(), 4) AS date_4; -- 23.05.24
select convert(varchar, getdate(), 5) AS date_5; -- 23-05-24
select convert(varchar, getdate(), 8) AS date_8; -- 12:57:23
select convert(varchar, getdate(), 9) AS date_9; -- May 23 2024 12:57:23:140PM
select convert(varchar, getdate(), 13) AS date_13; -- 23 May 2024 12:57:23:140
select convert(varchar, getdate(), 14) AS date_14; -- 12:57:23:140
select convert(varchar, getdate(), 20) AS date_20; -- 2024-05-23 12:57:23
select convert(varchar, getdate(), 21) AS date_21; -- 2024-05-23 12:57:23.140
select convert(varchar, getdate(), 22) AS date_22; -- 05/23/24 12:57:23 PM
select convert(varchar, getdate(), 23) AS date_23; -- 2024-05-23
select convert(varchar, getdate(), 25) AS date_25; -- 2024-05-23 12:57:23.140
select convert(varchar, getdate(), 101) AS date_101; -- 05/23/2024
select convert(varchar, getdate(), 102) AS date_102; -- 2024.05.23
select convert(varchar, getdate(), 103) AS date_103; -- 23/05/2024
select convert(varchar, getdate(), 104) AS date_104; -- 23.05.2024
select convert(varchar, getdate(), 105) AS date_105; -- 23-05-2024
select convert(varchar, getdate(), 111) AS date_111; -- 2024/05/23
select convert(varchar, getdate(), 112) AS date_112; -- 20240523
select convert(varchar, getdate(), 120) AS date_120; -- 2024-05-23 12:57:23
select convert(varchar, getdate(), 121) AS date_121; -- 2024-05-23 12:57:23.140