Node JS Sequelize v4 generate error while insert data into SQL Server

Question

When I try to insert record using Sequelize V4 with node js, this error occurs:

Conversion failed when converting date and/or time from character string

Above error occurred for createdAt and updatedAt columns.

My code is

  const School = sequelize.define('school_data', {
  id:{
        type:Sequelize.INTEGER,
        primaryKey:true,
        autoIncrement:true,
      },
  osteo_schl_id: Sequelize.STRING,
  osteo_schl_name: Sequelize.STRING,
  reset_status: Sequelize.STRING,
  last_update_dt: Sequelize.DATE,
});

let data = {
    osteo_schl_id:schoolId,
    osteo_schl_name:schoolName,
    reset_status:0
}

School.create(data);

add timestamps: false in model

shamon shamsudeen
– shamon shamsudeen

2017-11-30 05:48:57 +00:00
Commented Nov 30, 2017 at 5:48 — shamon shamsudeen
– shamon shamsudeen, Commented Nov 30, 2017 at 5:48

shamon shamsudeen · Accepted Answer · 2017-11-30 05:52:48Z

1

From the documentation http://docs.sequelizejs.com/manual/tutorial/models-definition.html#timestamps you can set createdAt and updateAt field as timestamps

id:{
        type:Sequelize.INTEGER,
        primaryKey:true,
        autoIncrement:true,
      }
       createdAt: Sequelize.DATE,
      updatedAt: Sequelize.DATE,

if you don't need this just set timestamps:false to model defenition

answered Nov 30, 2017 at 5:52

shamon shamsudeen

5,94120 gold badges76 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Node JS Sequelize v4 generate error while insert data into SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related