DECLARE @StartDateTime DATETIME 
,@EndDateTime DATETIME

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

WHERE
DATEADD(hour,-4,(dateadd(second ,myfield, '1/1/1970'))) >= @StartDateTime 
AND DATEADD(hour,-4,(dateadd(second ,myfield, '1/1/1970'))) <= @EndDateTime 

declare @StartInt int,
@EndInt int;

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

Where MyField >= @StartInt and MyField <= @EndInt;

drop table t1
Create table t1 (tim int, rem varchar(100))
select 86400 
INSERT INTO t1 VALUES (1251781074, 'day1')
INSERT INTO t1 VALUES (1251781074 + 86400, 'day2')
INSERT INTO t1 VALUES (1251781074 + 2*86400, 'day3')
INSERT INTO t1 VALUES (1251781074 + 3*86400, 'day4')
INSERT INTO t1 VALUES (1251781074 + 4*86400, 'day5')

Select DATEADD(hour,-4,(dateadd(second ,tim, '1/1/1970'))), * From t1

DECLARE @StartDateTime DATETIME  
,@EndDateTime DATETIME 
 
SELECT @StartDateTime = '2009-09-02 00:57:54.000'  
SELECT @EndDateTime = '2009-09-03 00:57:54.000 '

Select * from t1
Where 
 DATEADD(hour,-4,(dateadd(second ,tim, '1/1/1970'))) >= @StartDateTime  
AND DATEADD(hour,-4,(dateadd(second ,tim, '1/1/1970'))) <= @EndDateTime  

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

where finalcalledpartynumber = ('386') OR callingPartyNumber = ('386') 
AND dateTimeOrigination >= @StartInt  
AND dateTimeOrigination<= @EndInt 

where (finalcalledpartynumber = ('386') OR callingPartyNumber = ('386'))
AND dateTimeOrigination >= @StartInt  
AND dateTimeOrigination<= @EndInt 

where
dateTimeOrigination >= @StartInt 
AND dateTimeOrigination <= @EndInt
AND (finalcalledpartynumber = '386' OR callingPartyNumber = '386')