Skip to main content
Solved

Date time / timestamp and Timezone of user

  • May 20, 2024
  • 1 reply
  • 51 views

Forum|alt.badge.img+5

On MySQL there is a clear difference between the TIMESTAMP data type and the DateTime datatype.

If you want to store when an event in Amsterdam starts, you store the value as DateTime, as a user who wants to go to the event wants to know the time the event starts in Amsterdam.

If you want to store when a record changed you do this as TIMESTAMP, as the user wants to know when it happened relative to his local time.

Is there a way that can I make sure that Thinkwise handles this correctly? 

Best answer by Mark Jongeling

Hi Daan,

You can make use of Timezone functionality in the Thinkwise Platform:

Domains | Thinkwise Documentation (thinkwisesoftware.com)

Datetime you store in the database can be shown as stored, as well as shown in local time. The local time is set in IAM under Users. The timezone of the user will determine the exact time they see.

Store datetimes in your database as UTC and set the domain to show in local time.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3936 replies
  • Answer
  • June 5, 2024

Hi Daan,

You can make use of Timezone functionality in the Thinkwise Platform:

Domains | Thinkwise Documentation (thinkwisesoftware.com)

Datetime you store in the database can be shown as stored, as well as shown in local time. The local time is set in IAM under Users. The timezone of the user will determine the exact time they see.

Store datetimes in your database as UTC and set the domain to show in local time.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings