Reading DateTime from MSSQL Server

0
Hi All,   While accessing the datetime data from MS-SQL server the mendix reads it by adding +5:30 hours ? Why ?   How to manage this ?   Regards Sudhir
asked
1 answers
0
  1. Check if you attribute in entity is set as localized
    • When this is set, Mendix will automatically use the browser timezone for localizing the datetime attribute
  2. Check if the user you are logged in with, has timezone set to +5:30
    • When this is set, Mendix will use the User timezone to localize the datetime in MF's as well
  3. Try and use UTC variants mendix default functions like formatDateTimeUTC
answered