SQL - Storing timezone independent time values with datatimeoffset
In cases where it's necessary to store timezone independent time values in SQL Server, we can accomplish this by using the datetimeoffset data type. This post describes how this data type works with Power Apps.
Sql Datetime