nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Unable to fetch the right TIMESTAMP as per the user specified Time zone

User_VICIT

In the BI Report Data Model, we are trying to fetch the User Specified timestamp value but seems like we are not getting it as expected as the $_XDOTIMEZONE is not working as expected.

Can you please help us in finding the actual tag which we can use in the rtf or DM to fetch the user specified timestamp irrespective of the place they are in.

User >> Set Preferences >> Regional >> Time Zone specific

Thanks,
Mansi

Find more posts tagged with

BI Publisher

Systime

SYSDATE

Timestamp

Accepted answers

All comments

MandeepGupta

Hi @User_VICIT ,

Can you please elaborate a bit more? Are you trying to convert some date time from a backend table to a time in a timezone specified at "User >> Set Preferences >> Regional >> Time Zone specific" ?

Thanks.

User_VICIT

Yes, I am trying to fetch the user specific time from the specified timezone either SQL or any tags which I can use at the RTF level helps, as I have tried every approach but it is not working as expected.

Thanks

MandeepGupta

Hi @User_VICIT,

If you have the SQL ready to get user's preferred timezone, then you can use below function Data model and try:

CAST(wlif.start_date AT TIME ZONE wlaf.time_zone AS DATE) actual_date_time

where wlaf.time_zone —> timezone from user preferences.

Thanks.

User_VICIT

Hello Mandeep,

Usually the tag with XDO will be giving the timestamp details directly, I am only missing on only this one. Is it possible via any logics instead of putting the value as right now for the Time Zone I am getting EST & EDT and it is not coming as expected on the Timestamp though I need to hardcode. Any workaround on this?