TImestamp format in Oracle DB
As documented in the manual you have to use mi for minutes.  mm  is for the month number

select date,
       TO_CHAR(date,'dd/MM/yyyy HH24:mi:ss')  
from user.table 
where rownum&lt;10;