SQL-Oracle Error "ends before converting the entire input string"
I insert some value into sql Oracle.
My request in procedure:
INSERT INTO CHAT_CUSTOMER(customerId, customerName, status, lastLogin, isAdmin)
VALUES (v_customerId, v_customerName, v_status, to_date(v_lastLogin, 'dd/MON/yyyy hh24:mi:ss'), v_isAdmin);
And I ran my procedure:
V_CUSTOMERID := '111'; V_CUSTOMERNAME := 'AAA'; V_STATUS := 'Busy'; V_LASTLOGIN := '08/AUG/2015 21:02:44'; V_ISADMIN := '1';
Then I get the error:
ORA-01830: date format picture ends before converting entire input string
ORA-06512: at line 11
I have searched for some threads related to this, but this did not solve my problem. I add "to_date" but it still doesn't work.
Is there something wrong here? Please explain to me and help me solve the problem.
+3
source to share