We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL on Offering details in Learning module

Accepted answer
10
Views
2
Comments
edited Aug 29, 2021 3:21PM in Learning 2 comments

Summary

SQL on Offering details in Learning module

Content

Hi Experts,

I have a sql query to get course and offering details. But there is a difference between offering start date from SQL and actual value.

SQL:

SELECT DISTINCT lit.NAME course_name, lit.learning_item_id course_iddd,
                lit_off.learning_item_id off_iddd,
                lit.description_short course_description,
                li.DURATION course_duration,
                li.learning_item_type learningitemtype,
                li.learning_item_number course_id, li.currency_code,
                lit_off.NAME offering_name,
                lit_off.learning_item_number offering_id,
                TO_CHAR (lit_off.effective_start_date,
                         'yyyy/mm/dd'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!