2021年3月3日星期三

Time values from timestamp [sqlite3, Knex]

How can i store only IST time values like HH:MM in created_at row, values generated from timestamp are in UTC and DATE+TIME format

exports.up = function(knex) {      return knex.schema.createTable('tbl_xyz', (table) => {          table.increments('id').primary();          table.timestamp('created_at').defaultTo(knex.fn.now());          table.string('date');          table.string('url');          table.string('tags');      });  };  
https://stackoverflow.com/questions/66468005/time-values-from-timestamp-sqlite3-knex March 04, 2021 at 11:08AM

没有评论:

发表评论