SOLVED

ORA-01830

Asked by OracleDba••11 views•oracle
1
2
3
ORA-01830

ORA-01830
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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

Hope it helps!
OracleDba•

Post Your Solution