Problem in Time comparison

Question

Hi,

I am facing a problem while compare time with given time..

I am explaining this in detail.

please go through this.And please help me..

I have one table that contains two column those contains a interger value

1- StartTime as int

2-EndTime as int

Now i have to compare hour value from current time with these times.

I am Executing the query if hour value of Current time is greater than starttime and hour value of Current time is less than Endtime IN 24HOURS FORMAT.

Now the issue is.

If StartTime = 19 and

Endtime = 7(morning)

If Current hour value returns 20

then   20 > 19 its true  but 20<7 this value getting false....

20 is coming between evening 7 o'clock and morning 7 o'clock...but this query is getting false exception...

Please help me on this.....

I wll be very very highly obliged to u all.....