rrudnik
5/14/2015 - 12:22 PM

Displaying Boolean expression on example. Check if date is in the past

Displaying Boolean expression on example. Check if date is in the past

date_in_past.sql
content_copyfile_download
DECLARE
  hiredate date := SYSDATE +3;
  date_in_past BOOLEAN;
BEGIN
    date_in_past :=  NVL (hiredate < SYSDATE, FALSE);
    DBMS_OUTPUT.put_line(
        case date_in_past
            when TRUE then  'TRUE'
            when FALSE then 'FALES'
        END    
    );
END;