SET @DayID = (SELECT MAX(DayID) FROM dim_Date);
SET @DayDate = DATE_ADD((SELECT DayDate FROM dim_Date WHERE DayID = @DayID), INTERVAL 1 DAY);
SET @DayDateTime = DATE_ADD((SELECT DayDateTime FROM dim_Date WHERE DayID = @DayID), INTERVAL 1 DAY);
SET @DayDateTimeZero = DATE_ADD((SELECT DayDateTimeZero FROM dim_Date WHERE DayID = @DayID), INTERVAL 1 DAY);
SET @DayY = YEAR(@DayDate);
SET @DayM = MONTH(@DayDate);
SET @DayD = DAYOFMONTH(@DayDate);
SET @DayYW = YEAR(@DayDate);
SET @DayW = WEEKOFYEAR(@DayDate) - 1;
SET @DayQ = QUARTER(@DayDate);
SET @DayWD = WEEKDAY(@DayDate) + 1;
SET @DayMonthName = MONTHNAME(STR_TO_DATE(@DayM, '%m'));
SET @DayName = DAYNAME(@DayDate);
SET @DayID = @DayID + 1;

INSERT INTO dim_Date
 (DayDate, DayID, DayDateTime, DayDateTimeZero, DayY, DayM, DayD, DayYW, DayW, DayQ, DayWD, DayMonthName, DayName)
VALUE
 (@DayDate, @DayID, @DayDateTime, @DayDateTimeZero, @DayY, @DayM, @DayD, @DayYW, @DayW, @DayQ, @DayWD, @DayMonthName, @DayName);