Timezone clarification

[mebeingken]

@Teodor can you clarify the new timezone options for me?

Using your example:

Example 1

Display the stored date & time to the user in the user’s time zone.
In order to display the date & time to the users in their time zone, then you need to set the:

• Server Time Zone to UTC
• Database Time Zone Handling to UTC

With setting as UTC as you describe, should I expect that time will be displayed in the timezone of the browser, without adding any offset manually?

I have a new project, and have confirmed it has Etc/UTC for db connection and docker settings (and the server settings as well) and time is currently shown exactly as it is in the database (UTC).

I’m using mySQL 8 in a docker container.

Thanks!

[George]

Maybe this doc will help you:

Date and Time Settings for NodeJS

Intro In this tutorial we will explain the different date and time settings available for NodeJS and how to handle time zone options. Server Time Zone You can set the server time zone settings depending on your needs. The settings depend on if your are using Docker or not. Using Docker When you are using Docker, then you can adjust the server time zone settings in the target settings: [Screenshot_2] You can select UTC or your specific time zone from the list: [Screenshot_3] Not Using D…

[mebeingken]

That is what I took the example from.

The Example 1 says that to “display the date & time to the users in their time zone” use UTC rather than legacy.

But that does not work for me, so looking for confirmation that this is indeed intended to be the case.

[patrick]

The datetime strings use the ISO 8601 notation. An UTC datetime string looks like 2023-01-11T12:00:00.000Z, Z is the zone designator for the zero UTC offset. Without the Z it would be seen as a local time, with local times the T is often replaced with a space like 2023-01-11 12:00:00.000.

When you use one of the date formatters on the client it will use the local timezone, when the datetime string didn’t contain timezone information it will be handled as if it were the local timezone. With UTC datetime strings (or any other timezone offset) it will convert it to the timezone of the client.

[mebeingken]

@patrick

When you use one of the date formatters on the client it will use the local timezone,

That’s that part I was missing…it is the formatter that adjusts to local time.

Thanks for clarifying all that.

[George]

Hi Ken, feel free to edit the linked doc topic, to clarify the time usage as needed. It will be auto synced with our docs.

[mebeingken]

I have that permission?

[mebeingken]

@patrick I believe a bug with this:

UTC Timezone handling does not apply to subtables

Wappler Version : 5.3.1 Operating System : mac Server Model: node Database Type: mysql Hosting Type: docker Expected behavior When setting Timezone Handling to UTC, datetime values should be always returned in the ISO 8601 notation. Actual behavior If a datetime column is queried as part of a subtable, the datetime is returned as local rather than as UTC How to reproduce Create a query that utilizes a subtable and has datetime/ts columns: [Screenshot 2023-01-11 at 10.58.12 AM] Note the…

[George]

@mebeingken

I have that permission?

Yes all the docs are wiki topics with nice version control, so you can edit

[sylvainbaron]

Hi there,
I’m trying to set my localhost (Mac M1) docker project (Node+BS5+Postgresql) and my production docker project (linode DE/Frankfurt) with Europe/Paris + Local referring to your How To post but it doesn’t work.
Any idea?
Thanks