如何尝试:
select * from 'test_table'where end_date < CAST('2009-12-15' AS DATE)or start_date > CAST('2010-01-02' AS DATE)它将返回所有与您的日期范围完全不重叠的日期范围。

如何尝试:
select * from 'test_table'where end_date < CAST('2009-12-15' AS DATE)or start_date > CAST('2010-01-02' AS DATE)它将返回所有与您的日期范围完全不重叠的日期范围。