Hello MongoDB Community,
I’m currently working with MongoDB version 3.6.23 and have encountered difficulties using the $convert and $toDouble operators in my aggregation queries. When attempting to convert string fields to double, the queries don’t seem to function as expected.
Upon reviewing the documentation, I noticed that $convert and $toDouble were introduced in MongoDB 4.0. Therefore, they aren’t available in version 3.6.23.
Given this limitation, what alternative methods can I use in MongoDB 3.6.23 to convert string fields to double within aggregation pipelines? Any guidance or suggestions would be greatly appreciated.
Thank you in advance for your assistance.
Best regards,
Harinath J