Hi,
I have the following date format in database.
05-SEP-07
18-OCT-07
18-OCT-07
25-JUL-07
18-OCT-07
What I am trying to do is get only the full year from the date, example
2007
2008
2009
I tried to use extract function but that doesn't work due to ORA-01843: not a valid month.
Thanks in advance.
select extract(year from date '18-OCT-07') from dual;