Date time with zero time stamp

declare @datetime datetime;

set @datetime = getdate();

select @datetime;

select dateadd(year,datediff(year,0,@datetime),0);

select dateadd(month,datediff(month,0,@datetime),0);

select dateadd(day,datediff(day,0,@datetime),0);

Convert ISO date to normal date

CONVERT(datetime2, '2015-03-11T23:35:34.7610404Z', 126)