Query timezone issue

[former_member331439]

Hello

I have 2 different local UME users. The same query returns different values (datetime field) if I run it from either user1 or 2.

One user returns timestamp using local system time, the other using Grrenwich time.

Is there anybody who know how to set this behaviour?

Thank you a lot

Best regards

Fabio

SAP MII 12.2.5.58

[Former Member · Accepted solution]

Hi Fabio,

Check the users in UME and check the country and time zone set there for both the users.

Also which query are you using?

Regards,

Rohit Negi.

[former_member331439 · Accepted solution]

Hello Negi

You are right: the field is TIMEZONE.

Country hasn't effect on query results.

Thank you a lot

Best regards

Fabio