SQL Server 2005

Question

I created a table as emp_attendance in which I used some columns.

Now I want to compare current date of system with current date of table means shows that record which are entered in same date.

thank you.