Knexjs将mysql时间戳、日期时间列作为Javascript Date对象返回

const knex = require('knex')({
  client: 'mysql',
  connection: {
    host: 'your_host',
    user: 'your_user',
    password: 'your_password',
    database: 'your_database'
  }
});

knex.select('timestamp_column', 'datetime_column')
  .from('your_table')
  .then(rows => {
    rows.forEach(row => {
      const timestamp = new Date(row.timestamp_column * 1000); // 将时间戳转换为JavaScript Date对象
      const datetime = new Date(row.datetime_column); // 将日期时间列转换为JavaScript Date对象

      console.log('Timestamp:', timestamp);
      console.log('Datetime:', datetime);
    });
  })
  .catch(error => {
    console.error(error);
  })
  .finally(() => {
    knex.destroy();
  });