AlphaPress Publishing
P.O. Box 5942 Albany, NY 12205
Tel: 518-250-3890
Email: alphapress@hotmail.com  


  
Click to buy this book from Amazon

Section Menu 

News

Pindaro is now working on a comprehensive book on SQL Server 2014.  For any comments you can email the author at alphapress@hotmail.com.

  

 

 

How to use BETWEEN with the year() function

To contact the author click here

This article is from the book "Access 2007 Pure SQL

To download the sample database click here



The BETWEEN operator with the function

Find orders placed within a year range

Discussion:

In this example we use the year() function to extract the year out of the orderdate field so that we can use year values as the lower and upper boundaries.  All orders from 2009 and 2010 will be included in the result set due to the inclusivity characteristic of the BETWEEN operator. 

Code:

SELECT OrderID, orderdate, shippeddate

FROM orders

WHERE year(orderdate) BETWEEN 2009 AND 2010

ORDER BY orderdate DESC
 

Result: