Need to fetch user preferred date format for excel templates

Description: We need to incorporate the user-preferred date format in Excel reports. Please refer to the attached screenshot of the UI from which the date format needs to be fetched.

We are seeking guidance on the following:

1) Is there a direct :xdo construct available to retrieve the user-preferred date format?

2) If not, is there an SQL query that can fetch the user-preferred date format?

We have observed that similar FND_DATE_FORMAT can be retrieved from fnd_profile_option_values.profile_option_value. However, this value is not available for all users. Is there a specific setting required for the date format to be reflected here?