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?
Best Answer
As documented in the manual you have to use
mi
for minutes.mm
is for the month number