ORA-01849: hour must be between 1 and 12 - Oracle Database 12c Error Messages

Channel:

java frm

Subscribers:

5,740

Published on March 14, 2023 9:15:46 AM ● Video Link: https://www.youtube.com/watch?v=DkUksB91ezQ

Duration: 2:01

5 views

0

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

ORA-01849: hour must be between 1 and 12.
To know the timestamp format in your machine type the below SQL Query and insert the values accordingly to timestamp format.
SELECT value FROM V$NLS_PARAMETERS WHERE parameter = 'NLS_TIMESTAMP_FORMAT';

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