Q
Problem solve Get help with specific problems with your technologies, process and projects.

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;

  

Dig Deeper on Oracle database design and architecture

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close