SELECT (CASE
WHEN DATEPART(dw , regdate) = 1 THEN '일'
WHEN DATEPART(dw , regdate) = 2 THEN '월'
WHEN DATEPART(dw , regdate) = 3 THEN '화'
WHEN DATEPART(dw , regdate) = 4 THEN '수'
WHEN DATEPART(dw , regdate) = 5 THEN '목'
WHEN DATEPART(dw , regdate) = 6 THEN '금'
WHEN DATEPART(dw , regdate) = 7 THEN '토'
END ) AS Week
FROM (
SELECT '2017-06-18' as regdate
)AA
'DBMS > MSSQL' 카테고리의 다른 글
MSSQL SPLIT 구현 (0) | 2017.07.24 |
---|---|
MSSQL 중복 데이터 삭제 (0) | 2017.07.24 |
MSSQL PIOVT (0) | 2017.07.05 |
MSSQL MERGE / IF NOT EXISTS 문 사용법 (0) | 2017.06.07 |
MSSQL 금액에 콤마표시하기 (0) | 2017.05.25 |