ANKUSH THAVALI07 Sep, 20230 Comments24 Secs ReadORA-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 Hope it helps! Oracle DBAShare: ORA-01555: Snapshot too oldORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT