Node JS Sequelize ORM date issue

Asked May 25 '16 at 09:16

Active May 25 '16 at 09:16

Viewed 402 times

I am using sequelize ORM of node js to connect to mysql database.

I am having a field named "dob (date of birth)" that is of type date.

When I am storing any value in that field it is storing properly, but while fetching it is giving one date less than the one that is there in the database.

For example, I am storing "1990-10-27" in the database and while fetching it is returning me "Fri Oct 26 1990 18:30:00 GMT+0000 (UTC)".

Can anybody please help me with this.

asked May 25 '16 at 09:16

Swapnil Punekar

Please show us your code. [I tried, but I cannot reproduce this problem](https://gist.github.com/alexbooker/4900b3cfc284cab0510ca17088fbfcc5). It could be environmental. – Alex Booker May 25 '16 at 09:24
Maybe you should check your timezone – Martial May 25 '16 at 09:25
@Martial: In the configuration itself I have mentioned the timezone as "+05:30" as I want the timezone to be in IST. – Swapnil Punekar May 25 '16 at 09:27
@AlexBooker: I am fetching the field through "find" method of sequelize on my model which is giving me one date less than the actual value. This is happening for all the date fields of the database tables. – Swapnil Punekar May 25 '16 at 09:30
Have you noticed that the time returned is exactly 5:30 earlier than the correct value? – stuartd May 25 '16 at 09:36
DATE create a DATETIME field in database. Maybe you should define your field as DATEONLY instead. – Martial May 25 '16 at 09:36
@Martial: I have defined the field as DATEONLY – Swapnil Punekar May 25 '16 at 09:44
without your code it will be hard to help you more – Martial May 25 '16 at 12:14
What version of Node are you using? – Alex Booker May 26 '16 at 18:13
I removed from my sequelize configuration the "timezone" option and it resolved my issue. – Swapnil Punekar May 27 '16 at 11:42

Node JS Sequelize ORM date issue

0 Answers0