Knex: MySQL date type how to use local time zone during insert/update

[oliverzy]

Hi, I noticed that the query builder generated time as UTC timezone? Is it possible to use local time zone instead?

[pward123]

Just set the timezone option in the config object passed to initialize:

var knex = Knex.initialize({
  client: 'mysql',
  connection: {
    timezone : "+00:00"
    host     : '127.0.0.1',
    user     : 'your_database_user',
    password : 'your_database_password',
    database : 'myapp_test',
    charset  : 'utf8'
  }
});

See https://github.com/felixge/node-mysql#connection-options for option information