In both SQL Server and Oracle, you can enter a date range in two ways. The first is quite cumbersome:
dt_column >= 'date1' AND dt_column < 'date2'
The other way to do this is as follows:
dt_column BETWEEN 'date1' AND 'date2'
Category: Database