store DateTime standard at 12 noon - Mendix Forum

store DateTime standard at 12 noon


In the vast majority of all Mendix apps I worked on through the years only the Date-component is important and not also the Time-component.


Mendix stores DateTime-attributes standard at 00:00AM in the database when no specific time is specified. With the change from winter- to summer-time and vice versa coming up again these stored values in the database can jump from one date to another (23:00PM the previous day) which can cause serious issues.


I propose to store DateTime-attributes in the database at 12:00AM such that the Date-component remains unchanged.

0 answers