YTD, QTD, MTD, WTD table transformation SQL

A proper data modeling will help you answer this kinds of questions with:

YTD – From beginning of the Year until day of Today

QTD – From beginning of the Quarter until day of Today

MTD – From beginning of the Month until day of Today

YTD table
select t1.day_id, t2.day_id
INTO YTD_DAY
from LU_DAY t1, LU_DAY t2
where t1.day_id >= t2.day_id
and t1.year_id = t2.year_id

QTD table 
select t1.day_id, t2.day_id as qtd_day_id
INTO QTD_DAY
from LU_DAY t1, LU_DAY t2
where t1.day_id >= t2.day_id
and t1.QUARTER_id = t2.QUARTER_id

 MTD table
select t1.day_id, t2.day_id as mtd_day_id
INTO MTD_DAY
from LU_DAY t1, LU_DAY t2
where t1.day_id >= t2.day_id
and t1.month_id = t2.month_id

 WTD table
select t1.day_id, t2.day_id as wtd_day_id
INTO WTD_DAY
from LU_DAY t1, LU_DAY t2
where t1.day_id >= t2.day_id
and t1.week_id = t2.week_id