ORA-01830: Date format picture ends before converting entire input string

    You are trying to convert a string into a date using the to_date function, but the format mask is not of sufficient length:

    eg:


    SQL> select to_date('20051101 00:00:01', 'YYYYMMDD') from dual;
    select to_date('20051101 00:00:01', 'YYYYMMDD') from dual
                   *
    ERROR at line 1:
    ORA-01830: date format picture ends before converting entire input string

Adverteren bij Daisycon
Forum Messages
: ->  10-MAR-2008 07:47:00Concatenate date and timeBalaji S Reply
I am getting date and time seperately from an .asp page. In the backend i need to concatenate this date and time and need to insert/update it to a table.. i am using ORACLE9i.

Please help me!!

Thanks.
10-MAR-2008 08:08:13ResultDbMotive Reply
insert into mytable(datevalue) values (to_date(pDate||pTime, 'DD-MON-YYYY HH24:MI:SS'));

Add your message for ORA-01830
Name:email:
Validation Code:zr5w4bbbbehg43pqt
Enter Code above:
Title:
State your problem: