Check if current date is between two dates Oracle SQL

Question

I would like to select 1 if current date falls between 2 dates through Oracle SQL   I wrote an SQL after reading through other questions   https   stackoverflow com questions 2369222 oracle-date-between-query  https   stackoverflow com questions 2399753 select-from-table-by-knowing-only-date-without-time-oracle  But it returned only null  sysdate is the current date that is 01 05 2014 in date format DD MM YYYY   The SQL I wrote is   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    gt   TO DATE  28 02 2014    DD MM YYYY    AND to date sysdate  DD MM YYYY    lt  TO DATE  20 06 2014    DD MM YYYY

User · Answer

TSQL  Dates- need to look for gaps in dates between Two Date  select distinct e1 enddate  e3 startdate  DATEDIFF DAY e1 enddate e3 startdate -1 as  Datediff  from  temp e1     join  temp e3 on e1 enddate  lt  e3 startdate                     Finds the next start Time    and e3 startdate    select min startdate  from  temp e5 where e5 startdate  gt  e1 enddate  and not exists  select       Eliminates e1 rows if it is overlapped    from  temp e5  where e5 startdate  lt  e1 enddate and e5 enddate  gt  e1 enddate

User · Answer

SELECT to char emp login date  DD-MON-YYYY HH24 MI SS   A    FROM emp log A WHERE emp login date BETWEEN to date to char  21-MAY-2015 11 50 14    DD-MON-YYYY HH24 MI SS   AND to date to char  22-MAY-2015 17 56 52    DD-MON-YYYY HH24 MI SS    ORDER BY emp login date

User · Answer

You don t need to apply to date   to sysdate   It is already there   select 1 from dual  WHERE sysdate BETWEEN TO DATE  28 02 2014    DD MM YYYY   AND TO DATE  20 06 2014    DD MM YYYY      If you are concerned about the time component on the date  then use 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

[sql] Check if current date is between two dates Oracle SQL

TSQL: Dates- need to look for gaps in dates between Two Date

Examples related to sql

Examples related to oracle

Examples related to date

Examples related to between

Examples related to sysdate