Thanks so much for the help, I really appreciate it. Here's what I've got, but I'm gettig an error on the conversion:

Msg 8115, Level 16, State 2, Line 13

Arithmetic overflow error converting expression to data type datetime.

It's a pretty simple query, hitting a table of call logs, trying to find incoming and outgoing calls for an extension (386). Again, any help is greatly appreciated!

DECLARE @StartDateTime DATETIME

,@EndDateTime DATETIME,

@StartInt int,

@EndInt int;

SELECT @StartDateTime = '09/01/2009 01:00'

SELECT @EndDateTime = '10/13/2009 23:00'

select @StartInt = datediff(second, dateadd(hour, -4, '1/1/1970'), @StartDateTime),

@EndInt = datediff(second, dateadd(hour, -4, '1/1/1970'), @EndDateTime);

select DISTINCT callingPartyNumber AS 'Calling Number',

originalCalledPartyNumber AS 'Intended Called Number',

finalCalledPartyNumber AS 'Final Destination',

datetimeorigination = DATEADD(hour,-5,(dateadd(second ,dateTimeOrigination, '1/1/1970'))),

datetimedisconnect = DATEADD(hour,-5,(dateadd(second ,dateTimedisconnect, '1/1/1970'))),

duration AS 'Duration (seconds)'

from CDR

where finalcalledpartynumber = ('386') OR callingPartyNumber = ('386')

AND DATEADD(hour,-4,(dateadd(second ,dateTimeOrigination, '1/1/1970'))) >= @StartInt

AND DATEADD(hour,-4,(dateadd(second ,dateTimeOrigination, '1/1/1970'))) <= @EndInt

-- AND (duration) < 9

order by datetimedisconnect