Tell me, maybe someone came across ... Is there a T-SQL (MSSQL) function for converting the already recorded
DateTime values in the table to universal time (where there is no correction for the translation of hours).
CONVERT(CHAR(), DateTimeField, 127) and
CONVERT(CHAR(), DateTimeField, 126) for some reason give the same value, although it is written everywhere that the first should output Z - hour shift.
DATEDIFF(s, GETDATE(), GETUTCDATE()) not appropriate, as it only gives a shift for the current moment, which may differ from six months ago ...
Perhaps there are some locale based solutions? Or can I set a time zone for a transaction / connection?