You should look at the cast-and-convert-transact-sql page
For example, yyyy-mm-dd is 23 on the list there, so you can use:
convert(nvarchar, DateCol, 23)
to return a date formatted as yyyy-mm-dd. If you want hours, minutes and seconds as well, you can look at 20, 120, 21, 25 or 121.
The issue here is that your column doesn't actually seem to be a date column - but a text column. To fix this, you will need to convert into a date, then back out - something like this:
drop table if exists #dummydata
create table #dummydata (id int, title nvarchar(20), info nvarchar(50))
insert into #dummydata
select 1, 'abc', 'ii'
UNION select 2,'eee','6 Jun 2022 12:00AM'
UNION select 3, 'www', 'billy'
select * from #dummydata
update #dummydata set info = CONVERT(nvarchar, convert(datetime, info), 23) where id=2
select * from #dummydata