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

Related posts:

  1. VBScript Date Formatting For Filenames
  2. How to format a date in Oracle PL/SQL
  3. C# Format Date for Oracle
  4. Convert Date to XML Date/Time Format

Filed under: Oracle PL/SQL