When entering a date into the database it is 1 day behind

[Eric_F]

Wappler Version : 6.0.0
Operating System : Windows 11
Server Model: NodeJS
Database Type: SQLite
Hosting Type: Local

When doing a database insert into a “date” database field it sets it as 1 day behind.

This is the database field

Using a text input with type as date

If I try to set any date it will go into the database as the day before what was entered. When I entered today’s date 2023-11-27 it goes in as 2023-11-26.

I tried manually editing the date with the view/edit data and it still sets it to 1 day earlier.

[Cheese]

Take a look at Teodor’s write-up on Node date and time:

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…

See if that helps Eric?

[Eric_F]

I changed the node time to Etc/UTC and the database connection time was already on UTC.

Just tested and it still sets it 1 day behind.

[pranay]

I am facing a similar issue when I am currently in GMT+5:30, where as the server is in GMT.
It works fine when deployed on the server but when I run it locally it automatically maps to GMT so if I select 22-11-2023 it will use 21-112023 18:30(basically minuses 5 hours 30 mins)
PS: It is just the date field time is not needed here at all

[guptast]

There’s a Timezone setting under the Server Connect Global Settings. That may need to be set to Etc/UTC as well for the datetime to work correctly.

[Eric_F]

That one was changed as well with no effect.

[turn3636]

I have the same issue on MS SQL with Node. It’s just a date datatype in my database, there should be no time zone information in that.

[Eric_F]

@Teodor Any ideas on this?

[Eric_F]

@Teodor @George Could one of you take a look at this?

[Eric_F]

I went back and looked at this and I think it is just a visual bug in the database viewer.

Here you can see I select the 15th and when I click it changes to the 14th but when I pull up the data it is the 15th.