Sequelize store date part only in (mysql) table

Question

My application wants to store only date part in one of tables. In Sequelize there is only one data type, Sequelize.DATE, that can be used. On MySQL table it creates DATETIME column.

How can I have a column in database table to store only date, without time. part? MySQL is having separate DATE and DATETIME datatypes, but could not find a way to tell that in Sequelize.

Or can we make to ignore time part while running queries using Date object? (I know we can use getters and setters with properties. No idea whether it will work while running queries having conditions for the date field.)

Diosney · Accepted Answer · 2015-09-24 18:09:11Z

6

As of sequelize ^3.7.1 it does have support for a DATEONLY data type.

See http://docs.sequelizejs.com/en/latest/api/datatypes/ and https://github.com/sequelize/sequelize/blob/f678009d7514b81a6f87e12b86360e9a597e3ca8/lib/data-types.js#L357

for the implementations.

answered Sep 24, 2015 at 18:09

Diosney

10.6k15 gold badges70 silver badges113 bronze badges

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

Comments

PRS · Accepted Answer · 2016-11-15 06:56:09Z

5

Something of note... DATEONLY type in Sequelize v3 is NOT working as would be expected. It returns a Datetime with timezone, so if you are doing date comparisons they will not work as you expect unless your server timezone GMT. In my case, I'm working with holidays across timezones, so this was a headache for me. They do have a fix as of 2016-11-01 on the master branch, but it has not made it's way into v3 and there is no v4 yet. To work around the issue for now, you can do this in your model definition, which I found on that same link:

regDate: {
  type: DataTypes.DATEONLY,
  get: function() {
    return moment.utc(this.getDataValue('regDate')).format('YYYY-MM-DD');
  }
}

answered Nov 15, 2016 at 6:56

PRS

7128 silver badges18 bronze badges

Collectives™ on Stack Overflow

Sequelize store date part only in (mysql) table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related