I'm facing a problem with handling different timezones in MySQL. I have looked into similar questions that were previously raised, but I couldn't find a proper answer.
The issue I'm encountering is as follows: I have multiple microservices and a MySQL server. For instance, my mobile application runs in the timezone "+05:30," and the Node.js service runs in the same timezone. The problem arises when I fetch data from the mobile application, as it updates the database record with the current time without any adjustments. However, when data is received from the Node.js service on the backend, it subtracts "-5:30" from the stored value. Consequently, I end up with an incorrect value in the mobile application.
I need a way to handle DateTime properly for any timezone.