Dates stored and date retrieved vary in mysql DB

Navigation
1

In my database I have the date stored 01/02/2017 15:17:34 p.m.

Inserted as follows: 

objBD.query('SELECT u.ID_U, u.nombre from USUARIO u  where u.nombre=?',[nombre], function(err, rows, fields) {
    var created = new Date();
    console.log(rows);
            var post  = {ID_U:rows[0].ID_U,  ESTADO:estado, FECHA:created};
            var query = objBD.query('INSERT INTO  INTENTO SET ?', post, function(err, result) {
                for (var q = 0; q < array.length; q++) {
                    var post  = {ID_INTENTO:result.insertId,  TIEMPOB:array[q], VARIABLEB:1};
                    var query = objBD.query('INSERT INTO  BITACORA SET ?', post, function(err, result) {    

                    }); 
                };
            });
    }); 
};

But when I recover it: 

var getBitacoraIndividual=function(nombre,done){
var objBD = BD();
let res=[];

    objBD.query("select ID_U from usuario u where u.'NOMBRE'=?",[nombre], function(err, rows, fields) {
        objBD.query("SELECT Distinct fecha FROM bitacora b join intento i on i.'ID_INTENTO'=b.'ID_INTENTO' where i.'ID_U'=?",[rows[0].ID_U], function(err, rows, fields) {
            return done(null,rows);
        });
    });

    return res;             
}

Returns 01/02/2017 19:17:34 p.m. .

Why do I get the time +4 hours?

    
asked by hubman 03.02.2017 в 05:23
source

1 answer

0

I solved it by installing momentsjs link

code ... 

    var moment = require('moment-timezone');
    var created = new Date();//ver mi codigo de mi pregunta
    var created = moment.tz(created, "zonahoraria");
    created=created.format();
    console.log(created);

for the time zone see link

    
answered by 03.02.2017 в 06:45
Internet permission error Full calendar, a button to update events