Hi, I have a question about comparing date in PL/SQL.
I have a query:
select * from table1 where TO_CHAR(eff_date,'MM/DD/YYYY') < TO_CHAR(CURRENT_DATE,'MM/DD/YYYY')
When I run this query, I only got 5 records, I am expecting 7 records. The other 2 records is not showing up is because the month is 12, which is greater than the current_date month , which is 10.
Is there another way to compare date?
Thanks in advance.