LoginSignup
3

More than 5 years have passed since last update.

SequelizeのdefaultValue をNowにする方法なう

Last updated at Posted at 2018-11-13

SequelizeのdefaultValue: Sequelize.NOWは機能しない

Sequelizeの公式リファレンスで以下の例があるが、defaultValueがなぜか上手く機能しない。


const Foo = sequelize.define('foo', {
 // default values for dates => current time
 myDate: {
  type: Sequelize.DATE,
  defaultValue: Sequelize.NOW 
 },
 .....

正しくは、Sequelizeのリテラルを用いてDBの関数を呼び出すと良い。
以下の例文はmysqlを使用している場合。


const Foo = sequelize.define('foo', {
 // default values for dates => current time
 myDate: { 
  type: Sequelize.DATE, 
  defaultValue: Sequelize.literal('NOW') 
},
 .....

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
3