How to set my docker project time

Wappler General How To
, ,
#1

Hi everybody,
I need help setting my server date time.
I need the docker nodes’ server date-time to be Paris’ hour, and display Paris’ hour everywhere.
My webApp is hosted on Linode servers / Frankfurt, DE

I followed the instructions form https://community.wappler.io/t/date-and-time-settings-for-nodejs/46102 and setted up for targets Europe/Paris + DB > Local

I have 2 hours+ delay.
Even on my localhost web App.

Any ideas?
Thanks a lot

#2

Hi everybody,
Anybody knows?
@George
@Teodor
Many thanks

#3

Hi all,
Up ?
Thanks

#4

Hi there,
I feel stupid but can’t get the correct datetime for my project both on localhost / production. I tried several settings without success…
My customers are upset with this +2h I can’t fix…
Thanks

#5

Can you please explain what exactly is wrong with the datetime on your project?
Is it the {{NOW}} in server actions not returning the correct time?
Is it the database dates not stored properly?
Is it the database dates stored properly, but returned wrongly?
Is it the front end showing something differently?

It could be a lot of things, but if you don’t provide any additional info we won’t really be able to help.

#6

Hi Teodor,
I use everytime {{NOW}} for every insert or update.
Database stored dates are +2h from what I expect.
Displayed dates are the same than stored dates.

I tried several other settings, with the same result.

Development target :

  • Docker + ETC/UTC + Local

stored datetime is My local hour +2, it should be my computer datetime
sometimes while testing the DB Timezone Handling setting is not saved and reseted to Driver Dependent

Production target:

  • Docker + ETC/UTC + Local
  • Linode Frankfurt, DE

stored datetime is the local hour I would +2

Thanks

#7

What database are you using and what is your database timezone set to?

#8

Development. and Production:

  • Postgres 11.1.x
  • Both : Local
#9

Ok, what’s the database server timezone set to?

#10

The DB is in the docker container, I did not set specific timezone for DB :thinking:

#11

When using {{NOW}} in Server Connect it will use the timezone from where the Node server is running, not the database timezone. I don’t think your issue is the database timezone but the timezone of your node server.

#12

I also already tried to set my localhost node server (in docker) with the same +2h result.