Set defaultValue to todays date in a Sequelize migration

Question

I'm using Node Express with Sequelize and I want to set the defaultValue for the column "date" in the database to todays date. I tried with the following migration, but it didn't work, as it set the default date to be the same date as when I ran the migration. I want it to be set to the same date as when the row is created.

module.exports = {
  up: function (queryInterface, Sequelize) {
    return queryInterface.addColumn(
      'Todos',
      'date',
      {
        type: Sequelize.DATEONLY,
        allowNull: false,
        defaultValue: new Date()
      }
    )
  },

I can't understand how that would work.

score 32 · Answer 1 · answered Nov 19 '16 at 15:53

32

You need to use as a default value the MySQL function NOW().

So your column declaration should look like :

{ 
   type: Sequelize.DATEONLY,
   allowNull: false,
   defaultValue: Sequelize.NOW
}

Keep in mind that this will not populate the fields in your migration. They will be empty, since they were not created with sequelize.

answered Nov 19 '16 at 15:53

drinchev

19,201
4
67
93

2

Didn't work for me (2022-03-09), had to use `Sequelize.fn('now')` – Meekohi Mar 29 '22 at 21:25

score 30 · Answer 2 · answered May 07 '19 at 03:15

30

Sequelize.NOW will work in future but some versions(I tried 4.43.0) seem not support it. I succeeded in setting now() with using Sequelize.fn('now') .

{
  type: Sequelize.DATEONLY,
  allowNull: false,
  defaultValue: Sequelize.fn('now')
}

Reference: https://github.com/sequelize/sequelize/issues/4679

answered May 07 '19 at 03:15

asukiaaa

1,594
17
19

I need to use `Sequelize.fn('now')` on v5 also. – Bhoomtawath Plinsut Jul 23 '20 at 04:58
2

I had to use `Sequelize.fn('NOW')` ("now" in uppercase) – Teodoro Jul 31 '20 at 01:03

score 18 · Answer 3 · answered Feb 25 '20 at 14:47

https://github.com/sequelize/sequelize/issues/645#issuecomment-18461231

  createdAt: {
                field: 'created_at',
                type: DataTypes.DATE,
                allowNull: false,
                defaultValue: DataTypes.NOW
            }

score 4 · Answer 4 · answered May 25 '21 at 16:14

4

SQL Server users must use literal('CURRENT_TIMESTAMP')

createdAt: {
   field: 'created_at',
   type: DataTypes.DATE,
   allowNull: false,
   defaultValue: literal('CURRENT_TIMESTAMP'),
}

answered May 25 '21 at 16:14

Yuyo

41
3

ERROR: literal is not defined: this does not work for me. – Donald Kagunila Nov 24 '21 at 07:35
So sorry I just address this. For whoever has the same issue, `literal` must be imported from sequelize, it is a helper function. – Yuyo May 31 '22 at 12:53

score 3 · Answer 5 · answered Nov 24 '21 at 07:52

3

Use "literal", see below.

updated_at: {
  allowNull: false,
  type: Sequelize.DATE, 
  defaultValue: Sequelize.literal('CURRENT_TIMESTAMP')
}

answered Nov 24 '21 at 07:52

Donald Kagunila

329
2
5

score 2 · Answer 6 · answered May 18 '22 at 04:55

TIME: 2022-05-18

According to latest Sequelize Doc (version v6)

sequelize.define('Foo', {
  bar: {
     type: DataTypes.DATETIME,
     defaultValue: DataTypes.NOW
     // This way, the current date/time will be used to populate this column 
     (at the moment of insertion)
  }
});

score 1 · Answer 7 · answered Nov 19 '20 at 06:34

1

I had to use

createdAt: {
    type: DataTypes.DATE,
    defaultValue: Sequelize.fn('getdate')
},

answered Nov 19 '20 at 06:34

Dilhan Maduranga

2,201
1
16
12

score 1 · Answer 8 · edited May 25 '23 at 21:33

1

Only this worked for me.

createdAt: {
   field: 'created_at',
   type: DataTypes.DATE,
   allowNull: false,
   defaultValue: Sequelize.fn('NOW')
}

edited May 25 '23 at 21:33

jiminikiz

2,867
1
25
28

answered Mar 23 '21 at 12:25

Leandro Cortiz

21
1

could you put the json into a code block so that it is easier to read and explain a little about why this worked for you – Cookie Mar 23 '21 at 17:01

score 0 · Answer 9 · edited Nov 07 '22 at 15:39

0

Only this worked for me.

sale_date: {
  allowNull: false,
  type: Sequelize.DATE,
  defaultValue: Sequelize.fn('now')
},

edited Nov 07 '22 at 15:39

Tyler2P

2,324
26
22
31

answered Nov 03 '22 at 19:12

Matheus Gomes

1
2

1

Your answer could be improved by adding more information on what the code does and how it helps the OP. – Tyler2P Nov 07 '22 at 15:39

Set defaultValue to todays date in a Sequelize migration

9 Answers9