SQL Server datetime column datatype stores offset
You might want to consider looking at the following page:


Date and Time Data Types and Functions (Transact-SQL)


Ther you will find a link to the following information:


datetimeoffset (Transact-SQL)


The datetimeoffset data type is defined as:


  Defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock.


An example is given as follows:

DECLARE @datetimeoffset datetimeoffset(4) = '12-10-25 12:32:10 +01:00';  
DECLARE @date date= @datetimeoffset;  

SELECT @datetimeoffset AS '@datetimeoffset ', @date AS 'date';  



@datetimeoffset                  date  
-------------------------------- ----------  
2025-12-10 12:32:10.0000 +01:0   2025-12-10  

(1 row(s) affected)  



You might also want to look at the AT TIME ZONE (Transact-SQL) function when referencing a datetimeoffset value:


  Converts an inputdate to the corresponding datetimeoffset value in the target time zone. If inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate value is provided in the target time zone. If inputdate is provided as a datetimeoffset value, than AT TIME ZONE clause converts it into the target time zone using time zone conversion rules.