Quick Report SQL for Supplier Age Anlaysis

Hi Antonio,

not sure if I got you right, but do you mean something like this?

SELECT t.supplier_id,
       t.name,
       TRUNC((SELECT months_between(SYSDATE, t.creation_date)/12 FROM DUAL)) years_since_creation,
       TRUNC((SELECT months_between(SYSDATE, t.creation_date) FROM DUAL)) months_since_creation,
       TRUNC(SYSDATE-t.creation_date) days_since_creation
FROM SUPPLIER_INFO_GENERAL t