DataSource Controls :: Trying To Query Records From A Db Using A Date

I'm trying to query records from a db using a date. But somehow the db doesn't return records.

The datetime collums have the data stored in this format in the db as datetime :

12-Apr-10 12:45:12 AM
The string a have available is in this format : 12-Apr-10

I need to somehow strip the time part of so i can use my date string in the query.

When i use the below method the database converts the datetime to a rounded date (12-Apr-10 12:00:00 AM).
But when i query for that date i still get no results.

I tried this:

SELECT ID, PerformedBy, SystemId, ServerId, CAST(FLOOR(CAST(CreateDateTime AS FLOAT)) AS DATETIME) AS Expr1, Reason, Action, Summary, EnteredBy,
Collumn1, Collumn2
FROM Changes
WHERE ('Expr1 = '12-Apr-10 12:00:00 AM')

But this way the Expr1 collumn is not recognized.