When I read MSSQL with ORM EntityLoadByPK(), when ...
# lucee
c
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
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
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
✅ 3