Recently our server timezone was changed from CT to UTC - both app servers and db server.
How does this impact date fields in database?
When I saved a change in resource profile, I found that the last_updated_date field in srm_resources recorded the time in central timezone. I was expecting it to save it in UTC.
Is there any other setting that is set to Central Timezone that is driving this?
The GETDATE() function returns UTC time.
Release : 15.9
Component : CLARITY INTEGRATIONS & INSTALLATIONS
Full service stop start resolved the issue.