how to use mysql date_add function in sequelize?

Question

i just using sequelize for a few months. This ORM is really fast and efficient. But now im facing a problem, i need to use date_add in my query to add hours in my data.

Here is my code

obd_data.gps_data_2020.findAll({
        attributes:[
            'car_id',
            [sequelize.fn('max',sequelize.fn('date_add',sequelize.col('collect_datetime'),'INTERVAL 7 HOUR')),'collect_datetime'],
            [sequelize.fn('timestampdiff',sequelize.literal('hour'),sequelize.col('collect_datetime'),sequelize.fn('now')),'off_time']
        ],
        group:['car_id'],
        order:[['car_id','desc']]
})

its completely fine with another mysql query function such a timediff, max, sum , etc. But for date_add, i have no clue why this cant be work. And i haven't found same problem in stackoverflow,

Please help master, Thanks!

Adam Davarel Nostradatito · Accepted Answer · 2020-01-21 07:29:43Z

1

In the end, i used seqeulize.literal() to use date_add mysql func haha, thanks guys

answered Jan 21, 2020 at 7:29

Adam Davarel Nostradatito

1711 silver badge9 bronze badges

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

Comments

Greg Belyea · Accepted Answer · 2020-01-07 14:03:46Z

0

I think you'll have to define a virtual field in your model to do that, date_add does not appear to be a sequelize function.... https://sequelize-guides.netlify.com/virtual-columns/.. This is a field that does not get persisted or anything, just created on a select type thing

answered Jan 7, 2020 at 14:03

Greg Belyea

8781 gold badge5 silver badges15 bronze badges

Collectives™ on Stack Overflow

how to use mysql date_add function in sequelize?

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