ORA-01830: date format picture ends before converting entire input string.
428612Sep 1 2004 — edited Jul 12 2007I get an:
ORA-01830: date format picture ends before converting entire input string
when attempting to submit a new record using a date column with a date picker "Display As" field defined as:
Date Picker(DD-MON-YYYY-HH24-MI)
and the source value I'm using is:
select to_char(sysdate, 'DD-MON-YYYY-HH24-MI')
from dual
Doesn't seem to matter what format I use I get the same error. If I eliminate the time format from both the source value format and the data picker format it works. That is if I just use the date portion I can submit the record.
Any ideas?
Regards,
Steve