Date Range SQL

From Relyimah

Jump to: navigation, search

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'
Personal tools