In this post we will discuss how we can retrieve records between two dates in sql server 2008. Also check out my previous posts on:
Retrieve a record from last 7 days:
Suppose you have an employee table and JoiningDate is a column and you want to retrieve who are the employees joined in last 7 days, then you can query like below:
select * from Employees WHERE JoiningDate BETWEEN GetDate()-7 AND GetDate()
Retrieve record between particular dates:
Below is the query to retrieve records between particular dates.
SELECT * FROM Employees WHERE CONVERT(VARCHAR,JoiningDate,105)
BETWEEN CONVERT(VARCHAR,’30-08-2013′,105) AND CONVERT(VARCHAR,’05-09-2013′,105)
Retrieve record for particular month and year:
Below is the query that will retrieve records for particular month and year.
The below query will retrieve record for the month of july and year of 2013:
SELECT * FROM Employees
WHERE MONTH(JoiningDate) = 7 AND YEAR(JoiningDate) = 2013
You May Also like the Following SharePoint Online Tutorials:
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.