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!

date format picture ends before ..,

34428Feb 2 2002

hi,
When selecting the same query without the decimal it returns the number in words successfully. No problem. But when selecting the same query like below it gives error ORA-01830. Anybody please solve the problem.
ORA-MSG: Thans in Advance.
ORA-USR: Praveenkumar Talla(Pune, India)

SQL> select to_char(to_date(234.34,'j'),'jsp') from dual

ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2002

Added on Feb 2 2002

2 comments

359 views