Finding a specific date

[Mike Cornelison]

My registration_date column has to be a DATETIME type and I have to zero in on a specific date.

SELECT registration_date
FROM reserved
WHERE (
registration_date >= '2005-18-06 00:00:00'
)
AND (
registration_date <= '2005-18-06 23:59:59'
)

Is there a more streamlined way I can extract just the date from a DATETIME type, or is this the best or only approach?