Datename doesnt work!
688478Mar 4 2009 — edited Mar 4 2009Hi
I tried the following code in sql*Plus:
select datename(month, getdate()) from dual;
and i got the following error:
ORA-00904: "DATENAME": invalid identifier
I want to extract the current month as month name. Can you please point out the error here?
Thanks
Kamal