there is a query in the database saying:
Find all flights that depart TODAY and TOMORROW from Tokyo airport?
and I did write this query:
FROM tblFlights F
WHERE F.DepartureAirport ='TKY' AND F.DepartureDateTime='1/5/2010'
FROM tblFlights F2
WHERE F2.DepartureAirport ='TKY' AND F2.DepartureDateTime='2/5/2010'
logically it is OK i guess, but the datatype (domain) at the columns DepartureDateTime is deined as DATETIME and it contains data both for the DATE and the TIME and all I need is just DATE,
the problem is how do I make this query to check just for the DATE because it returns errors, plus deleting the time from this columns will not be the solution that will help me, I don't know if there is any trick like with VARCHARS when we can use "_%" or similar things to define what we want to check for....