MSSQL, 줄리안 데이트로 바꾸기
이달말일 SELECT ( DatePART ( yy, ( DATEADD(day, -1, DATEADD ( mm, 1, DATEADD(mm, DATEDIFF(mm, 0, getdate()), 0)) ) ) ) -1900 ) * 1000 + DatePART ( dy, ( DATEADD ( day, -1, DATEADD(mm, 1, DATEADD (mm, DATEDIFF(mm, 0, getdate()), 0) ) ) ) ) 전달말일 SELECT ( DatePART ( yy, ( DATEADD(day, -1, DATEADD ( mm, 0, DATEADD(mm, DATEDIFF(mm, 0, getdate()), 0)) ) ) ) - 1900 ) * 1000 + DatePART ( dy, ( DATEADD ( day..
2012. 1. 2.