Query:
select date,TO_CHAR(date,'dd/MM/yyyy HH24:mm:ss') from user.table where rownum<10;
02-08-18 05:21:02.301000000 PM 02/08/2018 17:08:02
Problem is minutes in above time are different 'mm' loses the precision of minutes and probably providing some garbage value. How do I format dates without losing precision?
mm
for minutes instead ofmi
-- I often make this mistake even after years using Oracle.