For more information, please refer to this announcement explaining best practices for getting answers to questions.
SQL on Offering details in Learning module
Summary
SQL on Offering details in Learning moduleContent
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'