Date and hour in wappler

[Valtenci]

I’m not understanding how the date and time works in wappler for my country,
1 - my date and time in brazil:

2 - my date in database:

3 - in list with formatting, shows one day and hour less:

4 - without format: ,

I would like you to keep this in my database and or timezone.

thanks.

[Hyperbytes]

What type of field are you storing the the value to? Datetime?
How do you store it, at database level or via wappler insert/ update action
Where is your sever located

[Valtenci]

hello, the field type and date, and I’m using mysql, both in insert and update

[Teodor]

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…

[Valtenci]

thank you very much, Teodor.

[Hyperbytes]

@Valtenci

the field type and date

Need to make that date time field

[Valtenci]

thansk.

[sid]

Because NodeJS/Knex applies ‘Z’ to the no-timezone date-time values returned from the DB server, when you apply date formatter on client side, it gets converted to your local system time.
‘Z’ denotes that the date time value is UTC timezone. So when you use Wappler’s date formatter, it automatically tries to convert it to your local OS’s timezone.

Add a replace formatter to remove Z, and then apply date formatter.
data.expiration.replace('Z','').formatDate('dd-MM-yyyy HH:mm')

[salvuccicarlos]

Hello,

I’m encountering a similar issue related to time zones in my application, and I’m wondering if anyone else has faced a similar problem or could offer some insights into what might be going wrong.

The Issue:

I have a datetime value stored in my MySQL database, which is 2023-08-22 00:00:00 . However, when I use the formatDate('yyyy-MM-dd HH:mm:ss') function on the server-side to transform this value, it gets converted to 2023-08-21 21:00:00.

I’ve read the Date and Time Settings for NodeJS post and configured my non-Docker app to the OS Default and the Database to Local (because my date data should be shown regardless of the users’ time zone.

Database Value Screenshot :

Server-Side Value from Query Screenshot :

Server-Side Transformation Screenshot :

Time Zone Settings:

• MySQL Database time zone: -03
• Node.js Server time zone (OS Default): America/Buenos_Aires
• System time zone: America/Buenos_Aires

Despite these settings, it seems like the formatDate function is modifying the time zone or offsetting the time by 3 hours (the same difference between my Local Timezone and the UTC time).

Questions:

1. Could there be any internal settings or configurations that might be affecting this?
2. Are there any workarounds or fixes for this issue? I need the formatDate function to return the same value that is displayed when querying the database.

Thank you for your time, and I’m looking forward to any advice or insights you may have.

[franse]

Carlos

@salvuccicarlos

it seems like the formatDate function is modifying the time zone or offsetting the time by 3 hours

Have you seen:

@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.

[salvuccicarlos]

But if my Database and App are configured for Local Timezone, why is Wappler substracting my -3 timezone? I mean, I need to use values as the are being showed in my database, without changing values.