Check if current date is between two dates Oracle SQL
You don't need to apply to_date()
to sysdate
. It is already there:
select 1from 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 1from dual WHERE trunc(sysdate) BETWEEN TO_DATE('28/02/2014', 'DD/MM/YYYY') AND TO_DATE('20/06/2014', 'DD/MM/YYYY');
TSQL: Dates- need to look for gaps in dates between Two Date
selectdistincte1.enddate,e3.startdate,DATEDIFF(DAY,e1.enddate,e3.startdate)-1 as [Datediff]from #temp e1 join #temp e3 on e1.enddate < e3.startdate /* Finds the next start Time */and e3.startdate = (select min(startdate) from #temp e5where e5.startdate > e1.enddate)and not exists (select * /* Eliminates e1 rows if it is overlapped */from #temp e5 where e5.startdate < e1.enddate and e5.enddate > e1.enddate);