Skip to Main Content

Oracle Database Discussions

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!

[b]error: date format picture ends before converting entire input string[/b

418164Mar 31 2004 — edited Mar 31 2004
when I insert some data into a table, which got a date field, it pops up this error.

insert inot test
values
('31-mar-2004 0:22:22')

after i take away the time part from the string, it works ok, seems the time is not recognized

i tried to put a line at the beginning, as below:
alter session set nls_date_format = "dd-mm-yyyy hh24:mi:ss"

then, it works, but it still comes out in the form "dd-mon-yyyy hh24:mi:ss"

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2004
Added on Mar 31 2004
2 comments
584 views