Use the Oracle PL/SQL “Extract” function to extract the Year, Month, Day into separate columns for sorting/grouping:
select EXTRACT(YEAR FROM Creation_Date) as Year, EXTRACT(MONTH FROM Creation_Date) as Month, EXTRACT(DAY FROM Creation_Date) as Day, Creation_Date from PO.PO_HEADERS_INTERFACE POI
Filed under: Oracle PL/SQL