How do you check whether a date is between two dates in Oracle?
How do you check whether a date is between two dates in Oracle? do you need to TO_DATE() sysdate? thanks paul, According the Gordon Linoffs solution below sysdate is already a date. You don't need SQL for this - in PL/SQL you can just do something like if sysdate between date '2014-02-28' and date '2014-06-21' then v := 1; end if; thanks Jeffrey Kemp this also works fine for me. How can I find the difference between two date columns in Oracle? Answer: Oracle supports date arithmetic and you can make expressions like "date1 - date2" using date subtraction to...