This blog shows on to use the Between Clause with the select and where clause to fetch some data within some time duration or date duration.
Syntax
Select column_list
From table
Where column1 between 'Date1' And 'Date2'
Example:
Select EmpName, EmpDateofJoining
From Emptable
Where EmpDateofJoining between '1/1/2010' AND '1/1/2011'