TO_CHAR can do this inside the SELECT:

SELECT TO_CHAR(column_date, 'DD-MM-YYYY HH24:MI:SS') AS "Formatted Date" 
FROM your_table;

Where <column_date> is your column in DATE format, 'dd-mm-yyy HH24...' is the datetime format.

OUTPUT: 17-08-2025 22:12:10