I have a table which has a column containing Active Directory timestamp. I have added a column in this table and trying to update it with datetime. I was trying the DATEADD in SSIS as well but that doesn't work either.
I am trying to use the following update command but it gives me the following error.
Ex: AD timestamp : 130153066505493000 converted timestamp: 2013-06-09 21:57:30.547
set [LastLogonTmstmp] = CONVERT(datetime,DATEADD(mi, -300, (LastLogonTmstmp_AD / 864000000000.0 - 109207)))
Msg 8115, Level 16, State 2, Line 26
Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.
Any help is much appreciated