Search code examples
sqlsql-serversmalldatetime

Getting Date Range

I want to get all the information between two given dates, How can I get a range of Date in SQL server with the datatype of "smalldatetime"

I'm expecting to get all the information start from start date to end date

Solution

  • I think you are looking for this :

    SELECT * 
from your_table
where date BETWEEN start_date AND end_date