[Solved] SQL Server: How to do WHERE statement to show only December 2015..?

by


Use YEAR and MONTH functions

… WHERE YEAR(SaleDate) = 2015 AND MONTH(SaleDate) = 12

Don’t use BETWEEN because you must to express the dates as literals, and that will be a problem considering that your SaleDate column could come with the time part in the future…

1

solved SQL Server: How to do WHERE statement to show only December 2015..?