How to filter date in SQL Server and get the records for today ?

WHERE        (Column_Name> GETDATE() - 1) AND (Column_Name< GETDATE() + 1)

How to get the sysdate ?

SELECT        GETDATE()

How to filter by date using between?

between dates : 07 May 2010 to 24 May 2010

WHERE        (Column_Name > '05/07/2010') AND (Column_Name < '05/24/2010')