SQL

sql between date range

SELECT * FROM Orders
WHERE OrderDate BETWEEN '2021-01-01' AND '2021-07-10';

SQL SERVER SELECT BETWEEN DATETIME

select * 
from blah 
where DatetimeField between '22/02/2009 09:00:00.000' and '23/05/2009 10:30:00.000'

sql between date range

SELECT * 
FROM table_name
WHERE column_name BETWEEN CONVERT(VARCHAR, '2022-01-30', 110)
	AND CONVERT(VARCHAR, '2022-04-30', 110)