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
Sudhir T
1 answers
0
- 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
- 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
- Try and use UTC variants mendix default functions like
formatDateTimeUTC
answered
Nirmalkumar Thandavamoorthy