Transform timestamp to different timezones

[Joss15]

Hi. I work on visualization, where need to show time based user timezone. Timestamp stores in UTC.

How do you think what is the best solution?

I tried to know information about user timezone but I can't get it. Looks one variant is create to field to choose user timezone in visualization like checkbox.

Does someone face with it?

Thanks

[Antoine04]

Hello,

You need to use the function LocalTime().

For exemple : 

localtime ('London')

Returns the local time in London, 2023-08-14 13:39:47.

Or the ConvertToLocalTime() function. Example :

ConvertToLocalTime('2023-08-14 08:39:47','Paris')

Returns '2023-08-14 10:39:47' and the corresponding internal timestamp representation.

Regards

Antoine

[Joss15]

Hi Antoine, thanks for your answer. Unfortunately when user open Apllication i can't know their timezone. And I am trying to find how can I use it or where hardcode it?