Showing date subtracting one date

[salvuccicarlos]

Hello, I’m having a problem with my database on a NodeJS app running on CentOS and using MySQL.

As showed on the image below, the front end on my Cloud server is showing dates subtracting one date to each record. The nework connection is getting the date correctly. This is only happening on my cloud server, my local server (running on my Mac) it’s working correctly. Any ideas?

[salvuccicarlos]

If I take the formatDate(‘dd/MM/yyyy’) shows the correct date.

The difference with my local Mac is that it assigns and hour to my date, I believe it’s a bug on the formatDate(‘dd/MM/yyyy’) option

This is how the Network connection looks on my Mac:

[Teodor]

Formatting a date ending with Z on the clientside converts the date in the local time.

[salvuccicarlos]

And how do I stop the server from converting the date to the client’s local time

[Teodor]

How to display a DB UTC date without it being converted to local time

Hi @patrick, I have a database date “2021-10-19T12:08:35.000Z” which comes through to the browser unchanged. I then apply formatDate(‘dd-MMM-yyyy HH:mm’) to format the date and it appears on the page as “19-Oct-2021 13:08”. So it looks like the formatDate function converts it to local time which for that date is UTC+1. I want to display the UTC date, i.e. “19-Oct-2021 12:08”, so how do I format it without it being converted to local time? Thanks Allan