How to select a time that is within a interval?

kuzze · #1 (**permalink**) 08-23-04, 05:36

Hi!

If i have a time and date i an database and want to check if that time and date are within a specified time interval

like if 2004-08-23 11:00 is within 2004-80-22:11:00 -> 2004-08-24 10:00

how do i do this?

kuzze · #2 (**permalink**) 08-23-04, 08:12

I solved it by using BETWEEN

Select ColumnName from TableName where DateColumnName BETWEEN '2004-80-22:11:00' AND '2004-08-24 10:00'

Thanks to Vijay G

Internet Services

Web Development

Digital Marketing

Consumer Tech