Hi Fineract Dev Community, In the Fineract documentation, it is mentioned that:
"Recently (after release 1.7.0), we introduced improved date time handling in Fineract. Date time is from now on stored in UTC and we are enforcing UTC timezone even on the JDBC driver, e.g., for MySQL: serverTimezone=UTC&useLegacyDatetimeCode=false&sessionVariables=time_zone='-00:00'" We are currently using MySQL as our database and would like to use the IST timezone instead of UTC. While I'm aware of the configuration steps required to switch to IST, I wanted to ask: * Are there any known issues or errors that might arise from using IST instead of UTC with Fineract? * What was the rationale behind enforcing UTC for datetime handling in the newer versions? Understanding this will help us ensure compatibility and avoid potential pitfalls. Looking forward to your insights. Best regards, Bhaskar Tiwari [https://ci3.googleusercontent.com/mail-sig/AIorK4xwPZE1QZDrygu965IrMxwqcvqBdkIzXxMp0niuCiOYlce_BZGNtYc5YwQWaRUvd1mvJMAMyto] Bhaskar Tiwari Senior Manager +91 8800188152 [https://ci3.googleusercontent.com/mail-sig/AIorK4xD8Fe69CCcmywbVUc86jabfOcbiI_QTiLOE9Mmm2AqhDRpbvYt_H4M-N6Jxm8X55lpHuouAQQ] "Print this mail only if absolutely necessary. Save Paper. Save Trees." Disclaimer: "This electronic mail message sent from StrideOne (Stride Fintree Private Limited) may contain Confidential/Restricted/Internal information and should only be viewed by the intended recipients. Under no circumstances may any such information be disclosed, copied, used or distributed to any unauthorized persons or entities without the written consent of Strideone. If you are not the intended recipient, any review, retransmission, dissemination or reliance on the content of these materials is strictly prohibited and may be the subject of legal action. If you received this email in error, please notify the sender and delete the message immediately."