Store DateAndTime in mendix default database

0
Hi Experts, I have a table called Program with Scheduled_date attribute. I scheduled a program on 30/03/2022 at 12:00 PM IST  in Scheduled_date attribute. But in database the value for Scheduled date is stored as 29/03/2022 .  I need to store what ever date which are entered in UI same should reflect on database also. How can I achieve this ?   Thanks in Advance.  
asked
2 answers
2

Hi Shalini Palani,

Have you already tried with the option localize to no?

 

answered
0

The DateTime is being stored in UTC, which I believe is 5:30 hours behind IST, hence the time you are seeing in the database. It is converted back to local time when you use it in Mendix. There is a bit more about this behaviour in the part 2 of the DateTime FAQ.
https://docs.mendix.com/refguide/datetime-handling-faq/

 

answered