Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: Unable to fetch the right TIMESTAMP as per the user specified Time zone
Hi @User_VICIT Can you try below format in your template? <?xdoxslt:current_time('ja-JP', 'Asia/Tokyo')?> Thanks.1 -
Re: Unable to fetch the right TIMESTAMP as per the user specified Time zone
I agree @User_VICIT. XDOTIMEZONE should work as well. But what I shared was a workaround from SQL side. Can you share the syntax you are using in your template? Thanks.1 -
Re: Unable to fetch the right TIMESTAMP as per the user specified Time zone
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_d…1 -
Re: Unable to fetch the right TIMESTAMP as per the user specified Time zone
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 >> R…1 -
Re: Oracle Analytics Community User's Map
This looks great. And good to see the distribution of users across globe :) Waiting for the dashboard now !!1
