Checking if time is beween other times

[it9888]

I'm building a website in which I have to do the follwing:A user gives a time and I have to check if this time is between 23:00(late at night) and 06:30(morning).How can I do that? I'm stuck here, please help!!! Has anybody come accross this?

[aspnetguy]

here's an article on comparing timehttp://www.freevbcode.com/ShowCode.Asp?ID=1350

[it9888]

Thanks aspnetguy, I'll have a look at it.

[netcracker]

it should be like this:

select * from table where date between #" date1 "# and #" date2 "#,conn