const model = sequelize.define('model', {//columns specifications
createdAt: {
type : TYPE.DATE,
allowNull : false,
get() {
const createAt = this.getDataValue('createAt')
// createAt is an instance of date, you could operate it with moment library
// to get ur format
return createAt
},
set(createAt) {
return this.setDataValue('createAt',createAt)
}
}
}, {
// options
timestamps: true // the createdAt and updatedAt will be stored by YYYY-MM-DD HH:mm:ss
});
new Date("Tue Mar 14 2017 16:02:21 GMT+0800 (中國標準時間)").getTime()
你的原有格式是啥格式?
YYYY-MM-DD HH:mm:ss
???如果你對資料庫進行crud的操作都是透過sequelize的話,應該沒問題