When I read MSSQL with ORM EntityLoadByPK(), when it's any date or datetime column the date displays a day back. In MSSQL the datetime is 2025-03-30 000000.000 but ORM gets 2025-03-29 230000.0000. Does anybody what causes this. What can I do?
z
zackster
04/19/2025, 10:08 AM
please always describe you stack and versions in use when asking for help!
sounds like possibly a daylight saying time problem?
what does your datasource config look like, are both servers in running in the same timezone?
w
websolete
04/21/2025, 1:15 PM
it's not a 'day' back, it's an hour back, which suggests your db server and web server are running in different timezones. correct that one that's wrong