By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,852 Members | 2,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,852 IT Pros & Developers. It's quick & easy.

Need to fetch current date records from SQL server 2008

P: 1
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.
Feb 14 '13 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,364
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
Feb 14 '13 #2

P: 9
Expand|Select|Wrap|Line Numbers
  1. WHERE CAST(Employee.[Date] AS DATE) = CAST(GETDATE() AS DATE)
Dec 9 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.