Ask the Expert

Check if date is greater than 2000 in PL/SQL

How to check if the date is greater than the year 2000 in PL/SQL?

    Requires Free Membership to View

    Login

You have two options here. One option is to convert the date value to a string and do a string comparison as follows: 
IF (TO_CHAR(date_val,'YYYY') > '2000') THEN
   
END IF;
Another option is to use the TO_DATE function to convert the comparison string to a date value. 
IF (date_val > TO_DATE('12/31/2000','MM/DD/YYYY')) THEN 
   
END IF;

This was first published in April 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top