ORA-01481: invalid number format model
449465May 26 2010 — edited May 26 2010Dear all,
I have a date coulmn in my table as for example: 20100414(yyyymmdd).
i want it to display as APR-2010 (MON-YYYY)
here is my select statement.
SELECT a.sys_cd, to_char( a.trans_dt_key,'MON-YYYY') TRANS_DATE, COUNT(*)
FROM sls_f_transaction a
GROUP BY a.sys_cd, to_char( a.trans_dt_key,'MON-YYYY');
ITS GIVING ME
ORA-01481: invalid number format model
Thank you