Database is in UTC, while the UI uses the time zone set on the Company Information page.
Database adds difference between UI and UTC because you want the contract to be ending at midnight… not in the middle of the day
So the UI end date is stored in date time = midnight
Database then converts date time to UI midnight (+/- UTC time difference)
This will come into play when a customer uploads contracts via API. The API timestamp must be intended for database time (i.e. contract end date +/- hours difference from UTC)