It seems user is trying to insert date to a table without using TO_DATE function. For example the below SQL may result in error if NLS_DATE_FORMATE is not set to MM/DD/YYYY.
INSERT INTO TEST VALUES('12/03/2018')
so the best way to insert date is use to_date function
INSERT INTO TEST VALUES(TO_DATE('12/03/2018', 'MM/DD/YYYY'))
Or if user doesn’t want to change the SQL statement then user will have to change the NLS_DATE_FORMAT parameter to MM/DD/YYYY in this case.
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center