Incident timestamps are current recorded as local server time (EST/EDT). They should be recorded as UTC in database. When the data is accessed, they should be translated to the local time based on the company settings.
- Write script to convert current timestamps of dbo.IT_Incident.Created and .LastModifed to UTC. They are currently recorded as Eastern Standard/Daylight Time.
- Find all instances where data for the .Created and .LastModified are set in code and switch to use UTC date.
- Find all instances where data for .Created and .LastModifed are retrieved in code and switch to convert from UTC to company local time.
- Make sure the IncidentEntity produces/saves the values correctly, as well.
Guest
