select * from blah where DatetimeField between '22/02/2009 09:00:00.000' and '23/05/2009 10:30:00.000'
SELECT * FROM table_name WHERE column_name BETWEEN CONVERT(VARCHAR, '2022-01-30', 110) AND CONVERT(VARCHAR, '2022-04-30', 110)