How to get the value between from date and to date in sql?
Consider the Table Employee has the following fields such as EId,Name,FromDate,ToDate
Suppose If u want to calculate the employee working days the follwing query results
Select * from Emp Where FromDate Between '2008-04-15 16:40:00' and '2008-04-15 18:47:0' and TODate Between '2008-04-15 00:00:00 and '2008-04-15 00:00:00'
Showing posts with label Sql Date. Show all posts
Showing posts with label Sql Date. Show all posts
Sunday, December 28, 2008
Subscribe to:
Posts (Atom)