topic Re: Transform timestamp to different timezones in App Development

Transform timestamp to different timezones

Joss15 — Fri, 14 Jun 2024 09:27:54 GMT

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

Re: Transform timestamp to different timezones

Antoine04 — Fri, 14 Jun 2024 09:31:25 GMT

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

Re: Transform timestamp to different timezones

Joss15 — Fri, 14 Jun 2024 09:46:44 GMT

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?