Remove Timezone on request with Node.js and express.js

Question

I have a API with node.js and express.js. In the database the fields of the type datetime are saved correctly, but in response to a request GET date fields come with 3 hours more due to time zone.

I’m making this requisition and consuming the json in a web application and in an app android nativo.

I would like to know how I could resolve it. Is there any possibility to remove the timezone in the API, or should I set something up in the database or server? I’m using MySQL.

Example:

**DB:** 2017-10-02 10:58:34

**JSON:** "2017-10-02T13:58:34.000Z"

Answer 1

I suggest using a library for conversion. For example, the extension of Moment.js to timzones, the Moment-timzone.

To do it natively you can use UTC and add the difference to your time, or format the date with the .toLocaleString('pt-br', {timezone: 'Brazil/brt'}). The problems that can arise are in the days of change between summer and winter time that I’m not sure the browser knows this information.

For example having the date of JSON repairs in which we can extract:

var json = "2017-10-02T13:58:34.000Z";
var date = new Date(json);

console.log('Dia:', date.getUTCDate(), 'Hora:', [date.getUTCHours(), date.getUTCMonth() + 1, date.getUTCMinutes()].join(':'));

console.log(date.toLocaleString('pt-br', {timezone: 'Brazil/brt'}));