node js Sequelize with MySQL date formate issue

Question

I developed node js services with Sequelize with MySQL Everything working good. I am storing data in DB with date and time with service but if I get the same data with service, node js automatically converting time (a wrong format which is not in the database), I want same time which is present in the database. to solve this issue I set the timezone in services and in the database but none of them is working. can anyone provide me with the solution.

post your code.

Sameer
– Sameer

2018-12-07 06:38:15 +00:00
Commented Dec 7, 2018 at 6:38 — Sameer
– Sameer, Commented Dec 7, 2018 at 6:38

Vivek Doshi · Accepted Answer · 2018-12-07 11:06:53Z

1

That's not the issue of node js , Sequelize by default gives the time in UTC , so that date time will be correct

Check : Just compare your date time with UTC , and check is that you are getting.

Solution : So what you can do is , just convert returned date and time to your timezone and you are good to go.

And that's a good practice if you are using UTC everywhere , you can get benefits when you are getting / showing in many countries.

answered Dec 7, 2018 at 11:06

Vivek Doshi

58.8k12 gold badges120 silver badges126 bronze badges

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

Comments

meBe · Accepted Answer · 2020-07-23 07:53:22Z

1

suggestion

you could include time format function in mysql for example

SELECT TIME_FORMAT("19:30:10", "%H %i %s");

result

TIME_FORMAT("19:30:10", "%H %i %s") 19 30 10

ref

edited Jul 23, 2020 at 7:53

answered Jul 23, 2020 at 6:10

meBe

1642 silver badges14 bronze badges

Collectives™ on Stack Overflow

node js Sequelize with MySQL date formate issue

2 Answers 2

Comments

suggestion

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

suggestion

Comments

Your Answer

Sign up or log in

Post as a guest

Related