데이타베이스/MSSQL
[MSSQL] 시간, 날짜 분리 (요일)
유키공
2021. 7. 12. 16:32
SELECT
DATEPART(YEAR, GETDATE()) AS 년,
DATEPART(MONTH, GETDATE()) AS 월,
DATEPART(DAY, GETDATE()) AS 일,
DATEPART(HOUR, GETDATE()) AS 시간,
DATEPART(MINUTE, GETDATE()) AS 분,
DATEPART(SECOND, GETDATE()) AS 초,
DATEPART(DW, GETDATE()) AS [요일(숫자)]