Q

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?

How to check if the date is greater than the year 2000 in PL/SQL?
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 last published in April 2006

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close