Thanks Jack.Incidentally, this does not even work:select CONVERT(datetime, '2006-12-12T23:45:12-08:00', 127)
even though the documentation seems to suggest otherwise, so the only format accepted by datetime style 127 seems to be yyyy-mm-ddThh:mi:ss.mmmZ (the .mmm part being optional).I guess the only real solution is to rewrite the query like this:SELECT DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), GETDATE()), CONVERT(datetime, '2012-10-29T23:00:00Z', 127)) T1, CONVERT(datetime, '2012-10-29 23:00:00', 121) T2
but I would have thought that the SQL Server would do that implicitly when I do an ISO8601 with time zone Z conversion from a varchar to datetime.Pete