Timezone settings and date fields in DB

Products

• Clarity PPM On Premise

Issue/Introduction

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.

Environment

Release : 15.9

Component : CLARITY INTEGRATIONS & INSTALLATIONS

Resolution

Full service stop start resolved the issue.