sql server – SQL query to select dates between two dates

To select records with dates between two specific dates in SQL Server, use the BETWEEN operator in a WHERE clause:

For inclusive date filtering, both start and end dates are included. Ensure the dates are in a format compatible with SQL Server (YYYY-MM-DD is standard).

If time values are part of the column, adjust the query to account for the full day range:

Replace TableName and DateColumn with your table and column names.