检查当前日期是否在两个日期之间 Oracle SQL

我想选择1如果当前日期位于 Oracle SQL 的 2 个日期之间。

看完其他问题后我写了一条SQL。

https://stackoverflow.com/questions/2369222/oracle-date- Between-query https://stackoverflow.com/questions/2369222/oracle-date-between-query

https://stackoverflow.com/questions/2399753/select-from-table-by-knowing-only-date-without-time-oracle https://stackoverflow.com/questions/2399753/select-from-table-by-knowing-only-date-without-time-oracle

但它只返回 null。sysdate是当前日期01/05/2014以日期格式DD/MM/YYYY.

我写的SQL是：

select 1 from dual 
WHERE to_date(sysdate,'DD/MM/YYYY') 
BETWEEN TO_DATE('28/02/2014', 'DD/MM/YYYY')
AND TO_DATE('20/06/2014', 'DD/MM/YYYY');

and

select 1 from dual 
WHERE to_date(sysdate,'DD/MM/YYYY') >= TO_DATE('28/02/2014', 'DD/MM/YYYY') 
AND to_date(sysdate,'DD/MM/YYYY') < TO_DATE('20/06/2014', 'DD/MM/YYYY'); 

您无需申请to_date() to sysdate。它已经在那里了：

select 1
from dual 
WHERE sysdate BETWEEN TO_DATE('28/02/2014', 'DD/MM/YYYY') AND TO_DATE('20/06/2014', 'DD/MM/YYYY');

如果您担心日期的时间部分，请使用trunc():

select 1
from dual 
WHERE trunc(sysdate) BETWEEN TO_DATE('28/02/2014', 'DD/MM/YYYY') AND
                             TO_DATE('20/06/2014', 'DD/MM/YYYY');