Reformat Date column in Oracle SQL Query to a time stamp

 Reformat Date column in Oracle SQL Query to a time stamp

Assume you have a date column but you want to see the time as well, then you need to reformat the column:

Use instead SELECT SOME_DATE_COLUMN the following:

SELECT to_char(SOME_DATE_COLUMN,'DD/MM/YYYY HH24:MI:SS') as SOME_DATE_COLUMN_FORMATTED

That's it!