[b]error: date format picture ends before converting entire input string[/b
418164Mar 31 2004 — edited Mar 31 2004when 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"