(imported topic written by RosaMartin)
I’m running the following query and get the error message below - can you help me with this?
SELECT A.ActionID,
A.ComputerID,
A.FixletID,
A.Username,
A.StartTime,
DATEADD(s, CAST(BFEnterprise.dbo.fn_ExtractField(‘EndTime’, 0, D.Fields) AS integer), ‘1970-01-01’) AS ‘EXPIRATION_TIME’,
A.Sitename,
A.ActionStatus
FROM BFEnterprise.dbo.BES_ACTION_DEFS D RIGHT OUTER JOIN
BFEnterprise.dbo.BES_ACTIONS A ON D.ID = A.ActionID
WHERE (D.ParentID != 1)
AND (BFEnterprise.dbo.fn_extractfield(‘EndTime’,0, Fields) is NULL
OR ((DATEADD(s, cast( BFEnterprise.dbo.fn_extractfield(‘EndTime’,0, Fields)as integer) , ‘1970-01-01’))) > getdate() )
ERROR:
Msg 248, Level 16, State 1, Line 1
The conversion of the varchar value ‘2832414266’ overflowed an int column. Maximum integer value exceeded.