일상 기록 창고

SET DATEFIRST 본문

프로그래밍/ms-sql

SET DATEFIRST

Crazy_Kong 2009. 9. 18. 09:54

SET DATEFIRST  1

 

시작일을 바꾸기 위해  사용.

 

쿼리문 

 SELECT DATENAME(wk, '2009-09-06') , DATENAME(wk, '2009-09-07'), DATENAME(wk, '2009-09-13')

 

결과

DATENAME(wk, '2009-09-06') , DATENAME(wk, '2009-09-07'), DATENAME(wk, '2009-09-13')

                        37                                     37                                          38

 

SET DATEFIRST  1 적용 시

 SELECT DATENAME(wk, '2009-09-06') , DATENAME(wk, '2009-09-07'), DATENAME(wk, '2009-09-13')

 

결과

DATENAME(wk, '2009-09-06') , DATENAME(wk, '2009-09-07'), DATENAME(wk, '2009-09-13')

                        37                                     37                                          37

 

'프로그래밍 > ms-sql' 카테고리의 다른 글

CTE 재귀 쿼리 사용하기  (0) 2009.09.18
SET LANGUAGE  (0) 2009.09.18
'프로그래밍/ms-sql' Related Articles more