Update Table with date in SQL SERVER Converting DATETIME TO VARCHAR OR Vice-Versa

 UPDATE mst_batch  SET BATCH_START_DATE =convert(varchar,'2022-07-22',103)WHERE Batch_CODE = 'BATCH-HR-20453-DB'

varchar to datetime

convert(datetime,PresentInstitutePostingDate,101)