CREATE FUNCTION
[fun_ConvertUTCToDateTimeZone](@datetimeUTC datetime, @TimeZoneToConvert nvarchar(60))
RETURNS datetime
AS
BEGIN
declare @fechaReturn datetime
set @fechaReturn = (SELECT CONVERT(datetime,@datetimeUTC)
AT TIME ZONE 'UTC'
AT TIME ZONE @TimeZoneToConvert);
Return @fechaReturn
END;
Ejemplo