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!

ORA-01722: invalid number while using TO_CHAR function.

817257Jan 3 2012 — edited Jan 3 2012

Hi All,
I was using this query from around past 1 year and everything was working fine.

select to_char ( '2012/12/23','YYYY/MM/DD') from dual;

how ever from monday onwards , this is returning me with the following error.

ORA-01722: invalid number

The NLS_DATE_FORMAT is DD-MON-RR in my oracle 11g version.

Please help me regarding this.

This post has been answered by satrap on Jan 3 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2012

Added on Jan 3 2012

6 comments

13,993 views