- 07 Sep, 2023
- 0 Comments
- 24 Secs Read
ORA-01830
ORA-01830
Solution :
- TO_DATE must be used with FORMAT while converting string to date.
- The FORMAT MUST match the string data
SQL> insert into emp values (101,'Learnomate',to_date('20-AUG-2023 09:54','dd-Mon-yyyy hh24:mi'));
1 row created.
SQL> select to_date('20-AUG-2023 09:54','dd-Mon-yyyy hh24:mi') from dual;
TO_DATE('
---------
20-AUG-23
SQL> select to_date('20-AUG-2023 09:54','dd-Mon-yyyy hh24:mi:ss') from dual;
TO_DATE('
---------
20-AUG-23