Select Today's records in the MS SQL SERVER Table

Case 1:

 SELECT CONVERT(DATE, columnName) as columnName,* FROM tblname WHERE   columnName=CONVERT (DATE, GETDATE())

Case 2:

  SELECT * FROM tblname WHERE columnName=CONVERT (DATE, GETDATE())