update pts_dec_head set invoice_date=convert(nvarchar,year(invoice_date))+‘-’+‘05’
+‘-’+‘29’+right(convert(nvarchar(19),invoice_date,120),9) where year(invoice_date)=2021 and month(invoice_date)=5 and day(invoice_date)=30
update pts_dec_head set invoice_date=convert(nvarchar,year(invoice_date))+‘-’+‘05’
+‘-’+‘29’+right(convert(nvarchar(19),invoice_date,120),9) where year(invoice_date)=2021 and month(invoice_date)=5 and day(invoice_date)=30