Solution :
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