Hi Tom , as a New Zealander I never knew that the Chatham Islands had a different time zome. Oh the arrogance.
I've just  started using Temporal Tables and can see how  using UTC  Date-Times in the Database makes sense even though it requires re-educating some of the Analysts.