How to get the values in between a particular range timestamps

Question

I have table in SQL Server 2008 called ,timestamplog which contains one column of name LogTime of typeINTEGER`

The values are like this:

1350468610,
1350468000,
1350381600,
1350295810

I need the values in between 1350468609 and 1350468001..

Please tell me how to query for those values.

I have try the following queries

select LogTime 
from timestamplog 
where LogTime between 1350468609 and 1350468001

select LogTime 
from timestamplog 
where LogTime >= '1350468610' and  LogTime <= '1350468000'

select LogTime 
from timestamplog 
where LogTime >= convert(decimal, 1350468610) and LogTime <= convert(decimal,1350468000)

select LogTime 
from timestamplog 
where LogTime >= convert(varchar, 12) and LogTime <= convert(varchar, 14)

But rows are not coming...

Actually the values in the table are the timestamps values stored as INTEGER in the table TIMELOG

IMP NOTE: Suppose if the values like 12,13,14 into table ,the above queries are working fine. But when I am comparing number of length 10 the query doesn't retrieve any values

Thanks in ADVANCE

Answer 1

Because 1350468001 is less than 1350468609, if you reverse the order, any of your queries would work. I'd go with...

select LogTime from timestamplog where LogTime between 1350468001 and 1350468609

which is an inclusive range.