====== SQL Server 날짜함수 ======

===== 올해 일자별 주(WEEK)차시 정보 =====
<code sql>
select a.num
    ,DATEADD(DAY,a.num-1,'20190101') as ymd
    ,DATEPART(WEEK,DATEADD(DAY,a.num-1,'20190101')) as week_no
from (
select row_number() over (order by column_name ) as num
from information_schema.columns
) a
where a.num < 366
;
</code>