Tag Info

New answers tagged

0

You can easily do this with a CLR Stored Procedure. [SqlFunction] public static SqlDateTime ToLocalTime(SqlDateTime UtcTime, SqlString TimeZoneId) { if (UtcTime.IsNull) return UtcTime; var timeZone = TimeZoneInfo.FindSystemTimeZoneById(TimeZoneId.Value); var localTime = TimeZoneInfo.ConvertTimeFromUtc(UtcTime.Value, timeZone); ...



Top 50 recent answers are included