Im really idealess about this ...

[[DEV]Sukey]

Hello about the Siege Battle ... I know the FIX Is heading around ... And used it with my Script ... so everything was fine till i cleaned up my database ...
Since then i cannot use the Script anymore and get this **** MSG -.-

[COLOR="Red"]Server: Msg 242, Level 16, State 3, Procedure FN_SetSiegeStartTime_U, Line 34[/COLOR]
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

If anyone could help me out or give me an idea how to fix it, would i be gladful ... While waiting for the Answer im going to solve the problem <.< or better said Trying ...

[jpxtreme]

in your FN_SetSiegeStartTime_U, re type the value. maybe it got messed up.

[[DEV]Sukey]

Oke im gonna look over this, Thanks *push button*

edit: Didnt find anything wrong for me there >.>

Thats the Code of it ...

CREATE FUNCTION dbo.FN_GetSiegeStartBinTime
(
@i_GetDate datetime
) RETURNS varbinary(4)
AS
BEGIN
DECLARE @v_siege_start_time varbinary(4)
DECLARE @v_siege_start_date varchar(14)
--// 다음공성전 시작시간 Default Setting : 일요일 9시
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
SELECT @v_siege_start_time = SUBSTRING(@v_siege_start_date,4,1) * 100000000
+ SUBSTRING(@v_siege_start_date,5,2) * 1000000
+ SUBSTRING(@v_siege_start_date,7,2) * 10000
+ SUBSTRING(@v_siege_start_date,9,2) * 100
+ SUBSTRING(@v_siege_start_date,11,2)

IF DATALENGTH(@v_siege_start_time) <> 4
SELECT @v_siege_start_time = 0x00000000

RETURN @v_siege_start_time
END