First of all, your database table must have a date type field to record the date of each record in the table. Say your table is called 'table1' and it has a date field called 'entrydate', then your sql query to retrieve all records of current date from table1 will look like:
SELECT * FROM table1 WHERE entrydate = getdate();