the value of date time on hyperSQL database is different with the value of date time on web application

0
Hi mendix support team,  when i record data date time into HyperSQL Database . The value of date time always be minus 1 day with the data input. i try to set time zone of application on application setting but the issue is not solved. please help me check this issue
asked
2 answers
1

Hi Ho Dung,

 

If you are seeing a date different in UI, then it might be because you have set the Localized option to yes for your Date time Attribute.

image.png

 

Another thing you have to note is that, in Mendix, the datetime attribute value is stored in UTC format. 

For example: The time component of a date selected from the date picker will always be the start of the day, which is 00:00, so in my database the value is stored in UTC format, which is based on where the application is hosted.

 

I hope this will help you. ATB!!

answered
0

thanks so much 

answered