develog

[mssql] string to date 본문

카테고리 없음

[mssql] string to date

냐옴 2019. 10. 1. 15:17
SELECT CONVERT(DATE, '20191001');
SELECT CONVERT(DATE, '2019-10-01');
SELECT CONVERT(DATE, '2019.10.01');

SELECT CONVERT(DATETIME, '20191001 15:12:34');
SELECT CONVERT(DATETIME, '2019-10-01 15:12:34');
SELECT CONVERT(DATETIME, '2019.10.01 15:12:34');
저작자표시 비영리 동일조건 (새창열림)
Comments