'My app was capturing input data in IST and now it is going to be in UTC. How to convert existing timestamps in the db?
My app was capturing user input data in IST. We have 2 years' records in the database. The current need is to capture the timestamps from user inputs in UTC to server multiple timezones. and now it is going to be in UTC. If the changes are implemented, new inputs will reflect as required but existing records will be messed up in the reports. Is there a way to convert all existing timestamps from IST to UTC in the database?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|