US states falls under different time zones. There are states that doesn’t fall within a single time zone. MI has area in Central and Eastern time zones. Also in Indiana. Arizona doesn’t follow daylight savings, so it comes under mountain time for a part of the year and Pacific time for the rest.
We should store the time in UTC (Select GETUTCDATE())
SQL Server has datetimeoffset data type to store offset time which can be converted to any time zone , but you need to have the time difference information due to the above mentioned problem.
SWITCHOFFSET function will switch the timezone from datetimeoffset.