SET @v_Start_Year = CONVERT(INT,SUBSTRING(CONVERT (CHAR,@p_TZ_Start_Date),1,4))
SET @v_End_Year = CONVERT(INT,SUBSTRING(CONVERT(CHAR,@p_TZ_End_Date),1,4))
SET @v_year = @v_Start_Year
/* Create array of specific start and end dates after taking into account */
/* Daylight Savings Time */
WHILE ( @v_year <= @v_End_Year )
BEGIN --> ***right here***
EXEC Convert_DST(@v_year, @v_DST_Start, @v_Local_DST_Start_Date, @v_Local_DST_Start_Time, @po_Error_Code OUTPUT, @po_Error_Msg OUTPUT)
IF @po_Error_Code > 0
BEGIN
SET @E_ERROR_CODE = @po_Error_Code
SET @E_ERROR_MSG = @po_Error_Msg
GOTO EXCEPTION
END
EXEC Convert_DST(@v_year, @v_DST_End, @v_Local_DST_End_Date, @v_Local_DST_End_Time, @po_Error_Code OUTPUT, @po_Error_Msg OUTPUT)
IF @po_Error_Code > 0
BEGIN
SET @E_ERROR_CODE = @po_Error_Code
SET @E_ERROR_MSG = @po_Error_Msg
GOTO EXCEPTION
END
IF( (@v_TZ_Start_Date <= @v_Local_DST_Start_Date) and (@v_Local_DST_Start_Date <= @v_TZ_End_Date))
BEGIN
--v_DST_Local_Date_array.EXTEND;
--v_DST_Local_Date_array(v_cnt) := @v_Local_DST_Start_Date;
@v_cnt := @v_cnt + 1
END
IF( @v_TZ_Start_Date <= @v_Local_DST_End_Date and @v_Local_DST_End_Date <= @v_TZ_End_Date)
BEGIN
--v_DST_Local_Date_array.EXTEND;
--v_DST_Local_Date_array(v_cnt) := @v_Local_DST_End_Date;
@v_cnt := @v_cnt + 1
END
@v_year := @v_year + 1
END
SET @v_End_Year = CONVERT(INT,SUBSTRING(CONVERT(CHAR,@p_TZ_End_Date),1,4))
SET @v_year = @v_Start_Year
/* Create array of specific start and end dates after taking into account */
/* Daylight Savings Time */
WHILE ( @v_year <= @v_End_Year )
BEGIN --> ***right here***
EXEC Convert_DST(@v_year, @v_DST_Start, @v_Local_DST_Start_Date, @v_Local_DST_Start_Time, @po_Error_Code OUTPUT, @po_Error_Msg OUTPUT)
IF @po_Error_Code > 0
BEGIN
SET @E_ERROR_CODE = @po_Error_Code
SET @E_ERROR_MSG = @po_Error_Msg
GOTO EXCEPTION
END
EXEC Convert_DST(@v_year, @v_DST_End, @v_Local_DST_End_Date, @v_Local_DST_End_Time, @po_Error_Code OUTPUT, @po_Error_Msg OUTPUT)
IF @po_Error_Code > 0
BEGIN
SET @E_ERROR_CODE = @po_Error_Code
SET @E_ERROR_MSG = @po_Error_Msg
GOTO EXCEPTION
END
IF( (@v_TZ_Start_Date <= @v_Local_DST_Start_Date) and (@v_Local_DST_Start_Date <= @v_TZ_End_Date))
BEGIN
--v_DST_Local_Date_array.EXTEND;
--v_DST_Local_Date_array(v_cnt) := @v_Local_DST_Start_Date;
@v_cnt := @v_cnt + 1
END
IF( @v_TZ_Start_Date <= @v_Local_DST_End_Date and @v_Local_DST_End_Date <= @v_TZ_End_Date)
BEGIN
--v_DST_Local_Date_array.EXTEND;
--v_DST_Local_Date_array(v_cnt) := @v_Local_DST_End_Date;
@v_cnt := @v_cnt + 1
END
@v_year := @v_year + 1
END