I am trying to build a query that returns the "last date" associated with a specific user. The "last date" is listed in the table as epoch time and I am attempting to convert the epoch time using DateAdd(). The statement below
generates an Arithmetic overflow error when the statement is executed.
select top 1 (select dateadd(s, (select max(dbo.history.action_created_date)as action_created_date), 19700101)
from dbo.history where dbo.history.ActionTakenBy like 'Nathan%') as MaxDate, dbo.history.act_name, dbo.history.ActionTakenDateText
from dbo.history
where dbo.history.ActionTakenBy like 'Nathan%';
Go to the complete details ...