We’re using Azure for the webgui and database hosting. If you use the “Current date and time”, it takes the Azure server local time / utc0. Not the client time, which can be in a different time zone.
Is it possible to display the client time in the webgui reports instead of the server time? I prefer to solve this in the DevExpress report if possible.
There is probably a workaround possible using some database functions and storing the users time zone in the database, but that is not preferred.
Best answer by René W
Hi Edo, that's unfortunate. But I’ve posted an idea for this:
For common interest;
We currently have a workaround that stores the time zone in a table using sys.time_zone_info. Then whe use a helper function that does a query like below:
declare @date_time datetime2 = '2020-11-12 07:57:00' -- this value must be UTC0.
select convert(datetime2, @date_time at time zone 'UTC' at time zone 'Hawaiian Standard Time') -- returns 2020-11-11 21:57
select tzi.name
, tzi.current_utc_offset
, convert(datetime2, @date_time at time zone 'UTC' at time zone tzi.name) as local_time
from sys.time_zone_info tzi
Hello René,
You could pass the current time via a hidden parameter to the report.
I can’t think of any other way to fix this other than the workarounds you already mentioned where not preferred.
Edo Spijker
Hi Edo, that's unfortunate. But I’ve posted an idea for this:
For common interest;
We currently have a workaround that stores the time zone in a table using sys.time_zone_info. Then whe use a helper function that does a query like below:
declare @date_time datetime2 = '2020-11-12 07:57:00' -- this value must be UTC0.
select convert(datetime2, @date_time at time zone 'UTC' at time zone 'Hawaiian Standard Time') -- returns 2020-11-11 21:57
select tzi.name
, tzi.current_utc_offset
, convert(datetime2, @date_time at time zone 'UTC' at time zone tzi.name) as local_time
from sys.time_zone_info tzi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.