Date fields in Oracle hold the time, but by default, the time is not displayed.

Below is a sample of how to format the date with time:

   TO_CHAR(CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') as CREATION_DATE

Example:

select Creation_Date, TO_CHAR(CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') as CREATION_DATE_Fmt 
from PO.PO_HEADERS_ALL
where Creation_Date is not null 
order by Creation_Date desc 

Notice how the time does not appear by default in the first field displayed:

Filed under: Oracle PL/SQL