declare @str varchar(128) = '2020-08-25 18:13:27.9000000 +05:00'
select @str, cast(@str as datetimeoffset ), convert(datetimeoffset, @str)
--2020-08-25 18:13:27.9000000 +05:00                                                                                               2020-08-25 18:13:27.9000000 +05:00 2020-08-25 18:13:27.9000000 +05:00

--(1 row(s) affected)



declare @str1 varchar(128) = '2020-08-25T18:13:27.9000000 +05:00'
select @str1, cast(@str1 as datetimeoffset ), convert(datetimeoffset, @str1)

--Msg 241, Level 16, State 1, Line 5
--Conversion failed when converting date and/or time from character string.

SELECT se_upload_off.OBJ_FIL as 'Филиал', se_upload_off.OBJ_PO as 'ПО', se_upload_off.OBJ_RES_kuem as 'РЭС', 
se_upload_off.OBJ_NM as 'Объект', se_upload_off.CTG_NM as 'Потребитель', se_upload_off.OBJ_CATEG as 'Категория', 
se_upload_off.CONTRACT_NM as 'Номер договора', se_upload_off.OBJ_ADDR as 'Адрес объекта' , se_supa_dg.modifyutc as 'Дата изменения в ДЖ'

, cast( replace(se_supa_dg.dat, 'T', ' ') as datetimeoffset) as 'Дата отключения'

, se_supa_dg.datvplan as 'Дата восстанолвения', 
se_supa_dg.vidotkl 'Тип события', se_supa_dg.onobkod 'Объект события', 
se_upload_off.email 'Эл. почта', se_upload_off.phone as 'Телефон' 
FROM se_upload_off, se_supa_dg
WHERE se_upload_off.F_OBJ_ID = se_supa_dg.eso_id
and se_supa_dg.predpr in ('33855301', '33855302', '33855303', '33855304', '33855305', '338555306')
and se_supa_dg.modifyutc >= DATEADD(hour, 8, cast(cast(DATEADD(day, -1, GETDATE()) as date)as datetime)) 
and se_supa_dg.dat > GETDATE()
order by se_supa_dg.dat

SELECT top(10) 
dat
, replace( dat, 'T', ' ' )  as mod_dat
, try_cast( replace( dat, 'T', ' ' ) as datetimeoffset ) as 'Дата отключения'
FROM se_supa_dg

SELECT top(10) 
dat
, replace( dat, 'T', ' ' )  as mod_dat
--, try_cast( replace( dat, 'T', ' ' ) as datetimeoffset ) as 'Дата отключения'
FROM se_supa_dg


select @@version

select @@version

SELECT top(10) 
dat
, replace( dat, 'T', ' ' )  as mod_dat
FROM se_supa_dg

SELECT top(10) 
dat
, replace( dat, 'T', ' ' )  as mod_dat
, cast( replace( dat, 'T', ' ' ) as datetimeoffset ) as 'Дата отключения'
FROM se_supa_dg

SELECT --top(10) 
 cast( replace( dat, 'T', ' ' ) as datetimeoffset ) as 'Дата отключения'
FROM se_supa_dg