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
没有评论:
发表评论