Can anyone help me to get below date format
'04/01/2019 7:20:29.581826 AM' to 2019-04-01T07:20:29.58
Can anyone help me to get below date format
'04/01/2019 7:20:29.581826 AM' to 2019-04-01T07:20:29.58
select convert(varchar(22),
cast('04/01/2019 7:20:29.581826 AM' as datetime2), 126)
select convert(varchar(22),
cast('04/01/2019 7:20:29.581826 AM' as datetimeoffset), 126)