select today's record in mssql

select * from table where cast(created_at as date) = cast(getdate() as date)