Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?