Need to fetch current date records from SQL server 2008

[bhargav042929]

Hi Experts,im a SAP PI consultant. im new to SQL server. i have a requirement where i need to fetch the records that are added today. i only have read access to the database. can some one help me with the query.

My Fields are Date, Empcode, start_time, End_Time. these records i need to fetch from the database.

[Rabbit]

SQL Server or MySQL? They are different things.

What you are asking for is a very basic query that is covered by tutorials for beginners. If you are going to be doing a lot of work in SQL, you should probably invest some time in a tutorial. This is a good one to try: http://www.w3schools.com/sql/default.asp

[swathee]

WHERE CAST(Employee.[Date] AS DATE) = CAST(GETDATE() AS DATE)