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
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