Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Export xlsx format from IR for date columns

Faezeh Ebrahimi4 days ago — edited 4 days ago

Hey all

I want to export from my IR in xlsx format but there's something different about displaying date columns in excel and IR.

I've set this code in Database Session to show all dates in APEX application based on Persian calendar :

BEGIN
 EXECUTE immediate 'ALTER SESSION SET NLS_CALENDAR=PERSIAN';
EXECUTE immediate 'ALTER SESSION SET NLS_DATE_FORMAT=''YYYY/MM/DD''';
END;

It works correctly but when I export from IR in xlsx format , I see my data columns are displaying based on GREGORIAN calendar.

but it works fine in csv format and all dates are showing on exact NLS_CALENDAR that I've set on app.

I've tried to_char(date_column,'yyyy/mm/dd','nls_calendar=persian') but I want to know why this happens only in xlsx format ?

This post has been answered by Gabriel Guzman on Jun 10 2024
Jump to Answer
Comments
Post Details
Added 4 days ago
2 comments
82 views