ORA-01830: date format picture ends before converting ... - Oracle Database 12c Error Messages

Channel:

java frm

Subscribers:

5,740

Published on March 14, 2023 9:08:47 AM ● Video Link: https://www.youtube.com/watch?v=HYOrMykJypw

Duration: 1:27

6 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.


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

Here in my machine date format is - DD-MON-RR (example: 14-MAR-23)
To know the date format in you machine type the below SQL Query and insert the values accordingly to dateformat.
SELECT value FROM V$NLS_PARAMETERS WHERE parameter = 'NLS_DATE_FORMAT';

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database