Skip to main content
Question

Quick Report SQL for Supplier Age Anlaysis

  • September 14, 2020
  • 1 reply
  • 156 views

AntonioL
Do Gooder (Former Employee)
Forum|alt.badge.img+4
  • Do Gooder (Former Employee)
  • 3 replies

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

1 reply

Forum|alt.badge.img+5
  • Do Gooder (Customer)
  • 18 replies
  • September 17, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings