SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to compare the date to hard coded date ?

843414Mar 23 2011 — edited Mar 23 2011

Hi,
How do I compare a date to hardcoded date?

IF MOD_LOAN_MOD_DATE > = 11/22/08 is the condition.

I am writing
TO_DATE(MOD_LOAN_MOD_DATE,'MM/DD/YY') >= to_date(11/22/08 ,'MM/DD/YY')

Error Message: Not a valid month.

How can I correct this ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2011

Added on Mar 23 2011

4 comments

5,133 views