Invalid Date when using sequelize.query

[Ankish76]

Issue Creation Checklist

• I understand that my issue will be automatically closed if I don't fill in the requested information
• I have read the contribution guidelines

Bug Description

When I am using sequelize.query to get data like this
sequelize.query( 'SELECT * FROM (SELECT p.*, (st_distance_sphere(POINT(a.latitude, a.longitude), POINT($lat, $lng))/1000) AS distance FROM Pharmacies p INNER JOIN Addresses a ON a.id = p.addressId WHERE p.brandCode = $brandCode OR $brandCode IS NULL) as C WHERE distance <= $maxDistance ORDER BY distance', { bind: { lat: cords?.lat || userLat, lng: cords?.lng || userLng, maxDistance, brandCode: brandCode || null, }, // raw: true, // type: QueryTypes.SELECT, model: Pharmacy, }, )

I am getting all the date columns as Invalid date.

However

1. When I am using models.Pharmacy.findAll() everything works as expected
2. When downgraded mysql2 to 3.5.2 everything works as expected

What do you expect to happen?

Date column values to be a valid Date

What is actually happening?

Date column values are Invalid Date

Environment

• Sequelize version: v6.37.1
• Node.js version: v18.19.0
• If TypeScript related: TypeScript version: v5.3.3
• Database & Version: MySQL 8.0.28
• Connector library & Version: mysql2 3.9.1

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I will need guidance.
• No, I don't have the time, but my company or I are supporting Sequelize through donations on OpenCollective.
• No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in resolving my issue.

---

Indicate your interest in the resolution of this issue by adding the 👍 reaction. Comments such as "+1" will be removed.

[ephys]

Thank you for the bug report

We are working on a fix, but I'll close this issue in favor of issue #17141, which reports the same thing