Hello,
I am trying to run a query using the SwitchOffset built in function to modify the timezone on a DatetimeOffset field.
I am receiving the following error: "The timezone provided to builtin function switchoffset is invalid."
Here is the query:
Select SWITCHOFFSET(La stFailedOn, Cast((GMTOFFSET * 60) as int)
from MyTable
Note: LastFailedOn is of DatetimeOffset type and GMTOFFSET...