SQL on Offering details in Learning module

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'