mysql和knexjs,Knexjs返回mysql时间戳，datetime列作为Javascript Date对象

i am using knexjs i insert data in the format YYYY-MM-DD HH:mm:ss e.g 2017-07-14 15:00:00 and after saving when the data is fetched the datetime column values are returned as javasript Date object.

i want to return those object in the format YYYY-MM-DD HH:mm:ss but it returning in the format YYYY-MM-DDTHH:mm:ss.000Z e.g 2017-06-23T06:44:44.000Z.

i am returning them by iterating and converting them manually. i was wondering if there is another way to do it like in mysql driver or knexjs configuration. currently my knexjs configuration is this.

var connection = require('knex')({

client: 'mysql',

connection: {

host: db.host,

user: db.user,

password: db.password,

database: db.database,

timezone: 'UTC'

}

});

解决方案

Change your connection object with this:

var connection = require('knex')({

client: 'mysql',

connection: {

host: db.host,

user: db.user,

password: db.password,

database: db.database,

timezone: 'UTC',

dateStrings: true

}

});