By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
IF (TO_CHAR(date_val,'YYYY') > '2000') THENAnother 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
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.