Skip to main content

Does someone have the SQL code required to create a Quick Report for Supplier Age Analysis ? 

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

 

Reply


Terms & ConditionsCookie settings